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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: BUG #15477: Procedure call with named inout refcursor parameter -"invalid input syntax for type boolean" error
Дата
Msg-id CAFj8pRBj-aQsKhyQ-+2Mdg0OrJRDwaROwQwArgHLcP53BJ6_wg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15477: Procedure call with named inout refcursor parameter -"invalid input syntax for type boolean" error  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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

В списке pgsql-bugs по дате отправления: