Re: Howto return values from a function - Mailing list pgsql-general

2008/5/16 A B <gentosaker@gmail.com>:
>> 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

You probably need to do

SELECT * FROM actionlist(123)


Ian Barwick