Re: [GENERAL] How to hint two columns IS NOT DISTINCT FROM each other in a join

2016-10-28 Thread Kim Rose Carlsen
Sorry for double post, just ignore this post.. From: pgsql-general-ow...@postgresql.org on behalf of Kim Rose Carlsen Sent: Thursday, October 27, 2016 6:34:58 PM To: pgsql-general@postgresql.org Subject: [GENERAL] How to hint two columns IS NOT DISTINCT FROM

[GENERAL] How to hint two columns IS NOT DISTINCT FROM each other in a join

2016-10-27 Thread Kim Rose Carlsen
Hi I was wondering if there is a way to hint that two columns in two different tables IS NOT DISTINCT FROM each other. So that the optimizer may assume if table_a.key = 'test' THEN table_b.key = 'test' . The equals operator already does this but it does not handle NULLS very well (or not at