diff options
| author | Bruce Momjian <bruce@momjian.us> | 2020-08-31 13:20:04 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2020-08-31 13:20:04 -0400 |
| commit | 5277f493dde7de00250d33a8ea79a5b93ee89dae (patch) | |
| tree | f527439e62c02074036bc556e87de2240e6854df /doc/src | |
| parent | 73952310bfcd4ebcffa3db7137d0b705f1bfdae2 (diff) | |
| download | postgresql-5277f493dde7de00250d33a8ea79a5b93ee89dae.tar.gz postgresql-5277f493dde7de00250d33a8ea79a5b93ee89dae.zip | |
doc: clarify the useful features of procedures
This was not clearly documented when procedures were added in PG 11.
Reported-by: Robin Abbi
Discussion: https://postgr.es/m/CAGmg_NX327KKVuJmbWZD=pGutYFxzZjX1rU+3ji8UuX=8ONn9Q@mail.gmail.com
Backpatch-through: 11
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/xfunc.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index 8bf497b2bf9..04ef0a85a72 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -84,8 +84,11 @@ A procedure is a database object similar to a function. The difference is that a procedure does not return a value, so there is no return type declaration. While a function is called as part of a query or DML - command, a procedure is called explicitly using - the <xref linkend="sql-call"/> statement. + command, a procedure is called in isolation using + the <xref linkend="sql-call"/> command. If the CALL command is not + part of an explicit transaction, a procedure in many server-side + languages can commit, rollback, and begin new transactions during + its execution, which is not possible in functions. </para> <para> |