[BUGS] BUG #14463: refcursor cann't used with array or variadic parameter?

Поиск
Список
Период
Сортировка
От digoal@126.com
Тема [BUGS] BUG #14463: refcursor cann't used with array or variadic parameter?
Дата
Msg-id 20161213152548.14897.81245@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14463: refcursor cann't used with array or variadic parameter?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14463
Logged by:          Zhou Digoal
Email address:      digoal@126.com
PostgreSQL version: 9.6.1
Operating system:   CentOS 6.x x64
Description:

postgres=# CREATE FUNCTION myfunc(variadic ref refcursor[]) RETURNS SETOF
refcursor AS $$                                               
begin   
 open ref[1] for select * from pg_class; 
 return next ref[1];       
 open ref[2] for select * from pg_class;
 return next ref[2];  
end;                               
$$ lANGUAGE plpgsql;
ERROR:  42804: variable "$1" must be of type cursor or refcursor
LINE 3:  open ref[1] for select * from pg_class;
              ^
LOCATION:  plpgsql_yyparse, pl_gram.y:2187
Time: 0.854 ms


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [BUGS] BUG #14462: Segment Fault recovery mode
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [BUGS] BUG #14463: refcursor cann't used with array or variadic parameter?