Re: Howto return values from a function

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Howto return values from a function
Date: 2008-05-16 08:32:19
Message-ID: dbbf25900805160132v3248cfa0ub9cd459760ac2c18@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Great! :D That did the trick!
Thank you so very much!

2008/5/16 Richard Huxton <dev(at)archonet(dot)com>:
> 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anton Melser 2008-05-16 08:56:06 Re: recommended way of separating data from indexes
Previous Message Richard Huxton 2008-05-16 08:28:25 Re: recommended way of separating data from indexes