pgsql: Support for OUT parameters in procedures
| От | Peter Eisentraut |
|---|---|
| Тема | pgsql: Support for OUT parameters in procedures |
| Дата | |
| Msg-id | E1kPL22-0007TC-Sp@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
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 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/2453ea142233ae57af452019c3b9a443dad1cdd0 Modified Files -------------- doc/src/sgml/catalogs.sgml | 5 +- doc/src/sgml/plpgsql.sgml | 38 ++++++++++ doc/src/sgml/ref/alter_extension.sgml | 11 +-- doc/src/sgml/ref/alter_procedure.sgml | 5 +- doc/src/sgml/ref/comment.sgml | 11 +-- doc/src/sgml/ref/create_procedure.sgml | 6 +- doc/src/sgml/ref/drop_procedure.sgml | 5 +- doc/src/sgml/ref/security_label.sgml | 11 +-- doc/src/sgml/xfunc.sgml | 59 ++++++++++++++++ src/backend/catalog/pg_proc.c | 9 ++- src/backend/commands/functioncmds.c | 57 ++++++++------- src/backend/executor/functions.c | 3 +- src/backend/parser/gram.y | 96 +++++++++++++++++--------- src/backend/utils/fmgr/funcapi.c | 4 +- src/include/catalog/pg_proc.h | 2 +- src/include/funcapi.h | 3 +- src/pl/plperl/expected/plperl_call.out | 18 +++++ src/pl/plperl/sql/plperl_call.sql | 20 ++++++ src/pl/plpgsql/src/expected/plpgsql_call.out | 19 +++++ src/pl/plpgsql/src/pl_comp.c | 1 + src/pl/plpgsql/src/sql/plpgsql_call.sql | 21 ++++++ src/pl/plpython/expected/plpython_call.out | 17 +++++ src/pl/plpython/plpy_procedure.c | 4 +- src/pl/plpython/sql/plpython_call.sql | 19 +++++ src/pl/tcl/expected/pltcl_call.out | 17 +++++ src/pl/tcl/sql/pltcl_call.sql | 19 +++++ src/test/regress/expected/create_procedure.out | 16 ++++- src/test/regress/sql/create_procedure.sql | 13 +++- 28 files changed, 416 insertions(+), 93 deletions(-)
В списке pgsql-committers по дате отправления: