| 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
>
>
| 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 |