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