On Mon, Aug 24, 2020 at 05:51:29PM +0200, Pavel Stehule wrote: > sure. Maybe enhancing about sentence like "it is not possible in a function." > > and > > "a procedure can commit (or rollback) and begin new transactions during its > execution"
OK, updated patch. -- Bruce Momjian <br...@momjian.us> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index 6de464c654..5dda2a80af 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 can commit, rollback, + and begin new transactions during its execution, which is not possible + in functions. </para> <para>