Horton

Support for OUT parameters in procedures

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 2453ea142233ae57af452019c3b9a443dad1cdd0
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2020-10-05T07:21:43Z
Releases: 14.0 
Support for OUT parameters in procedures

Unlike for functions, OUT parameters for procedures are part of the
signature.  Therefore, they have to be listed in pg_proc.proargtypes
as well as mentioned in ALTER PROCEDURE and DROP PROCEDURE.

Reviewed-by: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/2b8490fe-51af-e671-c504-47359dc453c5@2ndquadrant.com

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +3 −2
doc/src/sgml/plpgsql.sgml modified +38 −0
doc/src/sgml/ref/alter_extension.sgml modified +6 −5
doc/src/sgml/ref/alter_procedure.sgml modified +3 −2
doc/src/sgml/ref/comment.sgml modified +6 −5
doc/src/sgml/ref/create_procedure.sgml modified +2 −4
doc/src/sgml/ref/drop_procedure.sgml modified +3 −2
doc/src/sgml/ref/security_label.sgml modified +6 −5
doc/src/sgml/xfunc.sgml modified +59 −0
src/backend/catalog/pg_proc.c modified +7 −2
src/backend/commands/functioncmds.c modified +33 −24
src/backend/executor/functions.c modified +2 −1
src/backend/parser/gram.y modified +64 −32
src/backend/utils/fmgr/funcapi.c modified +3 −1
src/include/catalog/pg_proc.h modified +1 −1
src/include/funcapi.h modified +2 −1
src/pl/plperl/expected/plperl_call.out modified +18 −0
src/pl/plperl/sql/plperl_call.sql modified +20 −0
src/pl/plpgsql/src/expected/plpgsql_call.out modified +19 −0
src/pl/plpgsql/src/pl_comp.c modified +1 −0
src/pl/plpgsql/src/sql/plpgsql_call.sql modified +21 −0
src/pl/plpython/expected/plpython_call.out modified +17 −0
src/pl/plpython/plpy_procedure.c modified +2 −2
src/pl/plpython/sql/plpython_call.sql modified +19 −0
src/pl/tcl/expected/pltcl_call.out modified +17 −0
src/pl/tcl/sql/pltcl_call.sql modified +19 −0
src/test/regress/expected/create_procedure.out modified +13 −3
src/test/regress/sql/create_procedure.sql modified +12 −1

Documentation touched

Discussion