Re: new stored procedure with OUT parameters

2018-12-19 Thread Anton Shen
n Sun, Dec 16, 2018 at 12:05 PM Adrian Klaver wrote: > On 12/16/18 11:33 AM, Anton Shen wrote: > > Thanks for the thoughts. The part I'm missing is that why procedures > > with OUT param 'will not be called from SQL environments'? > > Pretty sure Pavel was referrin

Re: new stored procedure with OUT parameters

2018-12-16 Thread Anton Shen
Thanks for the thoughts. The part I'm missing is that why procedures with OUT param 'will not be called from SQL environments'? Thanks, Anton On Sat, Dec 15, 2018 at 10:03 AM Pavel Stehule wrote: > Hi > > Ășt 11. 12. 2018 v 7:20 odesĂ­latel Anton Shen <4175geo...@gmail

new stored procedure with OUT parameters

2018-12-10 Thread Anton Shen
Hi all, I was playing around with the stored procedure support in v11 and found that pure OUT parameters are not supported. Is there any reason we only support INOUT but not OUT parameters? psql (11.0 (Homebrew petere/postgresql)) dev=# CREATE PROCEDURE test_sp(a OUT int) LANGUAGE plpgsql AS $$ d