On 09/11/2009 22:43, Raymond O'Donnell wrote:
> On 19:59, wrote:
>> how can I write a function to return multiple rows? ( in plpgsql )
>
> Yep, it's all in the docs:
>
> http://www.postgresql.org/docs/8.4/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
[snip]
> Finally, you can use OUT parameters to return multiple values from the
> function - this is handy if you need to return just a few values.
Just to clarify further - this last option returns just a single row.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie