Thread: Returning multiple rows from plpgsql function

<p>Hi Everybody,<p>How can I return multiple rows from a plpqsql function. I wanted to write a function which gives me
theresult of the final select query from a bunch of nested select queries. What return type should use? The return type
%ROWTYPEonly returns a single row. In SQL function I can do this by stating that the function returns a setof record
butit doesnt work in plpgsql function.<p>Thanks,<p>Tarun<p><br /><hr size="1" />Do you Yahoo!?<br /><a
href="http://rd.yahoo.com/O=1/I=brandr/vday03/text/flow/*http://shopping.yahoo.com
/shop?d=browse&id=20146735">Yahoo! Shopping</a> - Send Flowers for Valentine's Day

On Mon, 17 Feb 2003, Mintoo Lall wrote:

> How can I return multiple rows from a plpqsql function. I wanted to
> write a function which gives me the result of the final select query
> from a bunch of nested select queries. What return type should use?
> The return type %ROWTYPE only returns a single row. In SQL function I
> can do this by stating that the function returns a setof record but it
> doesnt work in plpgsql function.

You might want to look at the Set Returning Functions document at
techdocs.postgresql.org.