git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e899742) | patch
Support for OUT parameters in procedures
Mon, 5 Oct 2020 07:09:09 +0000 (09:09 +0200)
Mon, 5 Oct 2020 07:21:43 +0000 (09:21 +0200)
commit 2453ea142233ae57af452019c3b9a443dad1cdd0
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
28 files changed:
doc/src/sgml/catalogs.sgml diff | blob | blame | history
doc/src/sgml/plpgsql.sgml diff | blob | blame | history
doc/src/sgml/ref/alter_extension.sgml diff | blob | blame | history
doc/src/sgml/ref/alter_procedure.sgml diff | blob | blame | history
doc/src/sgml/ref/comment.sgml diff | blob | blame | history
doc/src/sgml/ref/create_procedure.sgml diff | blob | blame | history
doc/src/sgml/ref/drop_procedure.sgml diff | blob | blame | history
doc/src/sgml/ref/security_label.sgml diff | blob | blame | history
doc/src/sgml/xfunc.sgml diff | blob | blame | history
src/backend/catalog/pg_proc.c diff | blob | blame | history
src/backend/commands/functioncmds.c diff | blob | blame | history
src/backend/executor/functions.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/backend/utils/fmgr/funcapi.c diff | blob | blame | history
src/include/catalog/pg_proc.h diff | blob | blame | history
src/include/funcapi.h diff | blob | blame | history
src/pl/plperl/expected/plperl_call.out diff | blob | blame | history
src/pl/plperl/sql/plperl_call.sql diff | blob | blame | history
src/pl/plpgsql/src/expected/plpgsql_call.out diff | blob | blame | history
src/pl/plpgsql/src/pl_comp.c diff | blob | blame | history
src/pl/plpgsql/src/sql/plpgsql_call.sql diff | blob | blame | history
src/pl/plpython/expected/plpython_call.out diff | blob | blame | history
src/pl/plpython/plpy_procedure.c diff | blob | blame | history
src/pl/plpython/sql/plpython_call.sql diff | blob | blame | history
src/pl/tcl/expected/pltcl_call.out diff | blob | blame | history
src/pl/tcl/sql/pltcl_call.sql diff | blob | blame | history
src/test/regress/expected/create_procedure.out diff | blob | blame | history
src/test/regress/sql/create_procedure.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /