Re: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean" error
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: stepaunov@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2018-11-01T08:04:23Z
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 > >
Commits
-
Fix bugs in plpgsql's handling of CALL argument lists.
- 4b0c3712c530 11.1 landed
- 15c7293477a6 12.0 landed