Re: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean" error

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: stepaunov(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean" error
Date: 2018-11-01 08:04:23
Message-ID: CAFj8pRBj-aQsKhyQ-+2Mdg0OrJRDwaROwQwArgHLcP53BJ6_wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> It is strange bug. When you use syntax =>, ":=" is obsolete (but still
> supported), then all is working
>
> postgres=# do $$
> declare
> v_ResultSet refcursor;
> v_cnt integer;
> begin
> call p1(v_cnt=>v_cnt, v_ResultSet => v_ResultSet);
> raise notice '%', v_ResultSet;
> end;$$
> ;
> NOTICE: <unnamed portal 4>
> DO
>
> looks so somewhere only new syntax is recognized and supported.
>

no, the behave is random. Looks on uninitialized variable

first call in session fails, seconds are ok

> Regards
>
> Pavel
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-11-01 08:36:29 BUG #15479: Documentation claims that client_min_messages is related to logging
Previous Message Pavel Stehule 2018-11-01 07:27:24 Re: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean" error