Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: BUG #15477: Procedure call with named inout refcursor parameter -"invalid input syntax for type boolean" error
Date
Msg-id CAFj8pRBj-aQsKhyQ-+2Mdg0OrJRDwaROwQwArgHLcP53BJ6_wg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15477: Procedure call with named inout refcursor parameter -"invalid input syntax for type boolean" error  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-bugs
Tree view




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

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #15477: Procedure call with named inout refcursor parameter -"invalid input syntax for type boolean" error
Next
From: PG Bug reporting form
Date:
Subject: BUG #15479: Documentation claims that client_min_messages is relatedto logging