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