Re: Returning multiple rows in 8.4

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