]> granicus.if.org Git - postgresql/commit
Recognize that IN subqueries return already-unique results if they use
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 19 Jan 2004 03:49:41 +0000 (03:49 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 19 Jan 2004 03:49:41 +0000 (03:49 +0000)
commit864412fd0a1e8983d4241383f13a5492bc795765
tree0c2bfa80e1a4eca68f6e51b5595a2ebaf2f5becf
parent5c625a9326e37093420044dcc70477cdbdd5f001
Recognize that IN subqueries return already-unique results if they use
UNION/INTERSECT/EXCEPT (without ALL).  This adds on to the previous
optimization for subqueries using DISTINCT.
src/backend/optimizer/util/pathnode.c