Re: stored procedures and type of returned result. - Mailing list 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