]> granicus.if.org Git - postgresql/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)
commit86e4ebb9af7ed07f11410d568e0fd72427f3b0e3
tree4d2b60c2d050d10a34265c71d2161d056ed346f3
parentc0d21bdb86b1eadd25ae56f07729aa53e1ca64c0
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