Add INSERT/UPDATE/DELETE RETURNING, with basic docs and regression tests.
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 Aug 2006 02:52:06 +0000 (02:52 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 Aug 2006 02:52:06 +0000 (02:52 +0000)
commit40fe1dc6e3625ca40b805b9c4d7260a1255c5184
treee69225a2a5a0ea694a6455b6066a0f41e9ea80e1
parentdbe680b8923eb92f83b98949e6408edde8ceeeb3
Add INSERT/UPDATE/DELETE RETURNING, with basic docs and regression tests.
plpgsql support to come later.  Along the way, convert execMain's
SELECT INTO support into a DestReceiver, in order to eliminate some ugly
special cases.

Jonah Harris and Tom Lane
35 files changed:
doc/src/sgml/ref/delete.sgml
doc/src/sgml/ref/insert.sgml
doc/src/sgml/ref/update.sgml
src/backend/access/common/printtup.c
src/backend/commands/prepare.c
src/backend/executor/execMain.c
src/backend/executor/spi.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/nodes/readfuncs.c
src/backend/optimizer/plan/planagg.c
src/backend/optimizer/plan/planner.c
src/backend/optimizer/plan/setrefs.c
src/backend/optimizer/prep/prepjointree.c
src/backend/optimizer/prep/preptlist.c
src/backend/optimizer/util/clauses.c
src/backend/parser/analyze.c
src/backend/parser/gram.y
src/backend/parser/keywords.c
src/backend/tcop/dest.c
src/backend/tcop/pquery.c
src/backend/tcop/utility.c
src/backend/utils/adt/ruleutils.c
src/include/catalog/catversion.h
src/include/executor/executor.h
src/include/nodes/execnodes.h
src/include/nodes/parsenodes.h
src/include/optimizer/planmain.h
src/include/tcop/dest.h
src/include/utils/portal.h
src/test/regress/expected/returning.out [new file with mode: 0644]
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/returning.sql [new file with mode: 0644]