Returning multiple rows from plpgsql function - Mailing list pgsql-sql

From Mintoo Lall
Subject Returning multiple rows from plpgsql function
Date
Msg-id 20030217200713.84465.qmail@web14809.mail.yahoo.com
Whole thread Raw
Responses Re: Returning multiple rows from plpgsql function  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
<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

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: PL/PGSQL EDITOR
Next
From: Stephan Szabo
Date:
Subject: Re: Returning multiple rows from plpgsql function