diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2018-03-14 11:47:21 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2018-03-14 12:07:28 -0400 |
| commit | 33803f67f1c4cb88733cce61207bbf2bd5b599cc (patch) | |
| tree | 9ec962aebf50eb4b16a585f83f490d9a5aa6f677 /doc/src/sgml/ref | |
| parent | 484a4a08abe316212d67d84bb8705b06e44f862d (diff) | |
Support INOUT arguments in procedures
In a top-level CALL, the values of INOUT arguments will be returned as a
result row. In PL/pgSQL, the values are assigned back to the input
arguments. In other languages, the same convention as for return a
record from a function is used. That does not require any code changes
in the PL implementations.
Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/call.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_procedure.sgml | 7 |
2 files changed, 9 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/call.sgml b/doc/src/sgml/ref/call.sgml index d45e3ec22e9..7418e19eeba 100644 --- a/doc/src/sgml/ref/call.sgml +++ b/doc/src/sgml/ref/call.sgml @@ -31,6 +31,10 @@ CALL <replaceable class="parameter">name</replaceable> ( [ <replaceable class="p <para> <command>CALL</command> executes a procedure. </para> + + <para> + If the procedure has output arguments, then a result row will be returned. + </para> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/create_procedure.sgml b/doc/src/sgml/ref/create_procedure.sgml index bbf8b03d04e..f3c3bb006cf 100644 --- a/doc/src/sgml/ref/create_procedure.sgml +++ b/doc/src/sgml/ref/create_procedure.sgml @@ -96,8 +96,11 @@ CREATE [ OR REPLACE ] PROCEDURE <listitem> <para> - The mode of an argument: <literal>IN</literal> or <literal>VARIADIC</literal>. - If omitted, the default is <literal>IN</literal>. + The mode of an argument: <literal>IN</literal>, + <literal>INOUT</literal>, or <literal>VARIADIC</literal>. If omitted, + the default is <literal>IN</literal>. (<literal>OUT</literal> + arguments are currently not supported for procedures. Use + <literal>INOUT</literal> instead.) </para> </listitem> </varlistentry> |