Search Postgresql Archives

Re: Howto return values from a function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

2008/5/16 Richard Huxton <dev@xxxxxxxxxxxx>:
> 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
>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux