]> granicus.if.org Git - postgresql/commit
Support hashing for duplicate-elimination in INTERSECT and EXCEPT queries.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Aug 2008 03:04:04 +0000 (03:04 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Aug 2008 03:04:04 +0000 (03:04 +0000)
commit368df3042783778031ece2b8580324516cd42de1
treedd6f9877cdc12654647a97785c4e7267cc7ac945
parent2d1d96b1cea8f67a095e8f28372af4081605f681
Support hashing for duplicate-elimination in INTERSECT and EXCEPT queries.
This completes my project of improving usage of hashing for duplicate
elimination (aggregate functions with DISTINCT remain undone, but that's
for some other day).

As with the previous patches, this means we can INTERSECT/EXCEPT on datatypes
that can hash but not sort, and it means that INTERSECT/EXCEPT without ORDER
BY are no longer certain to produce sorted output.
src/backend/commands/explain.c
src/backend/executor/nodeSetOp.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/outfuncs.c
src/backend/optimizer/plan/createplan.c
src/backend/optimizer/prep/prepunion.c
src/include/nodes/execnodes.h
src/include/nodes/plannodes.h
src/include/optimizer/planmain.h
src/test/regress/expected/union.out
src/test/regress/sql/union.sql