]> granicus.if.org Git - postgresql/commit
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)
commit7a3e30e608a25800a1f7fdfaaca4da3f0ac0fb07
tree215adabe95d76123f6120fc22e4b51b5a1baf4cd
parent5c9e9c0c42904648af5a03fe90db8050e31d603f
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]