git.postgresql.org Git - users/simon/postgres.git/commit

projects / users / simon / postgres.git / commit

summary | shortlog | log | commit | commitdiff | tree
(parent: 2cc5fd4) | patch

author	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 7 Oct 2008 19:27:04 +0000 (19:27 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 7 Oct 2008 19:27:04 +0000 (19:27 +0000)
commit	773c1a6f64e4b6bf808f8442ad7ae6109c557170
tree	13d394d892a5bb77ee7781d6a29356215277ecfc	tree
parent	2cc5fd481c8a4993f86ec29f4ef4ce52dc07f8be	commit \| diff

Extend CTE patch to support recursive UNION (ie, without ALL). The
implementation uses an in-memory hash table, so it will poop out for very
large recursive results ... but the performance characteristics of a
sort-based implementation would be pretty unpleasant too.

13 files changed:

doc/src/sgml/queries.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/select.sgml		diff \| blob \| blame \| history
src/backend/executor/nodeRecursiveunion.c		diff \| blob \| blame \| history
src/backend/nodes/copyfuncs.c		diff \| blob \| blame \| history
src/backend/nodes/outfuncs.c		diff \| blob \| blame \| history
src/backend/optimizer/plan/createplan.c		diff \| blob \| blame \| history
src/backend/optimizer/prep/prepunion.c		diff \| blob \| blame \| history
src/backend/parser/parse_cte.c		diff \| blob \| blame \| history
src/include/nodes/execnodes.h		diff \| blob \| blame \| history
src/include/nodes/plannodes.h		diff \| blob \| blame \| history
src/include/optimizer/planmain.h		diff \| blob \| blame \| history
src/test/regress/expected/with.out		diff \| blob \| blame \| history
src/test/regress/sql/with.sql		diff \| blob \| blame \| history

Simon's dev repository