On 10/25/26 11:00 AM, Tom Lane wrote:
Adrian Klaver <[email protected]> writes:
On 10/25/26 8:34 AM, Mark wrote:
"To call a function with OUT parameters, omit the output
parameter(s) in
the function call: ..."
That's what you do in SELECT, but in CALL you write all six
arguments (and the ones corresponding to OUT parameters
have to be variables).
From here:
https://www.postgresql.org/docs/current/sql-call.html
"CALL executes a procedure."
"To call a function (not a procedure), use SELECT instead."
So is the problem down to the OP defining a function not a procedure and
therefore not being able to use CALL to get at the OUT parameters?
regards, tom lane
--
Adrian Klaver
[email protected]
