]> 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)
commit6f44fe7f121ac7c29c1ac8553e4e209f9c3bfbcb
tree5489479a43a5f1fe55927183e81e6bfb53935195
parent27c6619e9c8ff80cd78c7f66443aa005734cda90
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