]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Allow rel_is_distinct_for() to look through RelabelType below OpExpr.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 17 Sep 2017 19:28:51 +0000 (15:28 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 17 Sep 2017 19:28:51 +0000 (15:28 -0400)
commit244b4a37eb8e253e5221477534c2a2f0a9c23630
tree88b01c82746a9886e2fd9563ee7dfb225cdef467
parent66fe509be0166058f53bf857b21eae125de30fc5
Allow rel_is_distinct_for() to look through RelabelType below OpExpr.

This lets it do the right thing for, eg, varchar columns.
Back-patch to 9.5 where this logic appeared.

David Rowley, per report from Kim Rose Carlsen

Discussion: https://postgr.es/m/VI1PR05MB17091F9A9876528055D6A827C76D0@VI1PR05MB1709.eurprd05.prod.outlook.com
src/backend/optimizer/plan/analyzejoins.c