Re: stored procedures and type of returned result.

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: stored procedures and type of returned result.
Дата
Msg-id 412B1B47.6090202@archonet.com
обсуждение исходный текст
Ответ на stored procedures and type of returned result.  (Patrice OLIVER <oliverp21@free.fr>)
Список pgsql-sql
Patrice OLIVER wrote:
> 
> Hello, I got this error message :
> 
> ERROR:  set-valued function called in context that cannot accept a set
> CONTEXT:  PL/pgSQL function "lsttable" line 5 at return next

You need to treat set-returning functions as though they are tables.  SELECT * FROM lsttable();
NOT  SELECT lsttable();

--   Richard Huxton  Archonet Ltd


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