]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: cd97f98) | patch
Allow SQL-language functions to return the output of an INSERT/UPDATE/DELETE
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 31 Oct 2008 19:37:56 +0000 (19:37 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 31 Oct 2008 19:37:56 +0000 (19:37 +0000)
commit9b46abb7c47de8aa408a8c83666fd67c5447eb85
tree034991f27008de03ff71f505431b10a1b2ae5e5etree | snapshot
parentcd97f98844b5640b1cdc701c691c962155dce3b4commit | diff
Allow SQL-language functions to return the output of an INSERT/UPDATE/DELETE
RETURNING clause, not just a SELECT as formerly.

A side effect of this patch is that when a set-returning SQL function is used
in a FROM clause, performance is improved because the output is collected into
a tuplestore within the function, rather than using the less efficient
value-per-call mechanism.
doc/src/sgml/xfunc.sgml diff | blob | history
src/backend/executor/execQual.c diff | blob | history
src/backend/executor/functions.c diff | blob | history
src/backend/tcop/dest.c diff | blob | history
src/backend/utils/fmgr/README diff | blob | history
src/include/executor/functions.h diff | blob | history
src/include/nodes/execnodes.h diff | blob | history
src/include/tcop/dest.h diff | blob | history
src/test/regress/expected/rangefuncs.out diff | blob | history
src/test/regress/output/create_function_1.source diff | blob | history
src/test/regress/sql/rangefuncs.sql diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.