A B wrote:
How you generate the results is up to you. when you have them you
either use RETURN NEXT or RETURN QUERY to return them to the caller.
Now I get the reply
ERROR: set-valued function called in context that cannot accept a set
CONTEXT: PL/pgSQL function "actionlist" line 11 at return next
It's a source of rows, so you need to treat it like a table or a view:
SELECT * FROM actionlist(...);
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general