Hi,
I heard from my colleagues that we have an extension that does a similar
thing. I'm attaching the source. It creates operator "==" for some data
types, that works like "IS NOT DISTINCT FROM". You can then perform hash
joins on this operator. Apparently the hash join machinery supports
non
Hello,
We are using PostgreSQL to execute some SQL scripts "auto translated" from HIVE
QL, where the join operator "<=>" is heavily used. The semantic same operator
in PostgreSQL is "IS NOT DISTINCT FROM".
However, we found when "IS NOT DISTINCT FROM" is used in joins, only nested
loop plan ca