git.postgresql.org Git - users/gsingh/postgres.git/commit

projects / users / gsingh / postgres.git / commit

author	Peter Eisentraut <peter@eisentraut.org>
	Mon, 5 Oct 2020 07:09:09 +0000 (09:09 +0200)
committer	Peter Eisentraut <peter@eisentraut.org>
	Mon, 5 Oct 2020 07:21:43 +0000 (09:21 +0200)
commit	2453ea142233ae57af452019c3b9a443dad1cdd0
tree	c38325aa838a785924c9add942c17021e3e8098b	tree
parent	e899742081fa24bf52d4a32103ef854a3a85865d	commit \| diff

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

Postgres clone for personal branches

RSS Atom