Horton

Implement SQL-spec RETURNS TABLE syntax for functions.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 69a785b8bfe076847f72317a41964821e85ccfd6
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2008-07-18T03:32:53Z
Releases: 8.4.0 
Implement SQL-spec RETURNS TABLE syntax for functions.

(Unlike the original submission, this patch treats TABLE output parameters
as being entirely equivalent to OUT parameters -- tgl)

Pavel Stehule

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +3 −2
doc/src/sgml/func.sgml modified +27 −1
doc/src/sgml/plpgsql.sgml modified +20 −1
doc/src/sgml/ref/create_function.sgml modified +44 −4
doc/src/sgml/xfunc.sgml modified +60 −19
src/backend/catalog/information_schema.sql modified +2 −1
src/backend/catalog/pg_proc.c modified +2 −1
src/backend/commands/functioncmds.c modified +6 −4
src/backend/parser/gram.y modified +85 −4
src/backend/utils/adt/ruleutils.c modified +144 −1
src/backend/utils/fmgr/funcapi.c modified +8 −6
src/bin/pg_dump/pg_dump.c modified +74 −22
src/bin/psql/describe.c modified +17 −8
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/pg_proc.h modified +6 −1
src/include/nodes/parsenodes.h modified +3 −2
src/include/utils/builtins.h modified +3 −1
src/pl/plpgsql/src/pl_comp.c modified +4 −2
src/pl/plpython/plpython.c modified +6 −3
src/test/regress/expected/plpgsql.out modified +32 −0
src/test/regress/expected/rangefuncs.out modified +37 −0
src/test/regress/sql/plpgsql.sql modified +23 −0
src/test/regress/sql/rangefuncs.sql modified +18 −0