Re: INOUT parameters in procedures

On Tue, Mar 20, 2018 at 10:09 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> 2018-03-20 15:18 GMT+01:00 Merlin Moncure <mmoncure(at)gmail(dot)com>:
>> >> postgres=# create or replace procedure p(a inout int default 7) as $$
>> >> begin return; end; $$ language plpgsql;
>> >> CREATE PROCEDURE
>> >> Time: 1.182 ms
>> >> postgres=# call p();
>> >> a
>> >> ───
>> >> 0
>> >> (1 row)
>> >
>> >
>> > I wrote patch
>>
>> Confirmed this fixes the issue.
>
> Thanks for info

You're welcome. Working with this feature some more, I noticed that:
A) you can't assign output variables with into:
CALL p(1) INTO i; // gives syntax error

B) you can't assign via assignment
i := p(1); // gives error, 'use CALL'

C) but you *can* via execute
EXECUTE 'CALL p(1)' INTO i; // this works!

...I'm glad 'C' works, as without that there would be no useful way to
get values out of procedures called from within other
procedures/functions as things stand today. 'A' ideally also out to
work, but I'm not sure 'B' should be expected to work since it's
really a thin layer around SELECT. What do you think?

merlin