X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 17636475B99
	for <pgsql-sql@postgresql.org>; Mon, 17 Feb 2003 15:07:14 -0500 (EST)
Received: from web14809.mail.yahoo.com (web14809.mail.yahoo.com
	[216.136.224.230])
	by postgresql.org (Postfix) with SMTP id 56967475B8F
	for <pgsql-sql@postgresql.org>; Mon, 17 Feb 2003 15:07:13 -0500 (EST)
Message-ID: <20030217200713.84465.qmail@web14809.mail.yahoo.com>
Received: from [66.139.15.154] by web14809.mail.yahoo.com via HTTP;
	Mon, 17 Feb 2003 12:07:13 PST
Date: Mon, 17 Feb 2003 12:07:13 -0800 (PST)
From: Mintoo Lall <tlqmail@yahoo.com>
Subject: Returning multiple rows from plpgsql function
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-595128334-1045512433=:83066"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/384
X-Sequence-Number: 11782

--0-595128334-1045512433=:83066
Content-Type: text/plain; charset=us-ascii


Hi Everybody,

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.

Thanks,

Tarun



---------------------------------
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
--0-595128334-1045512433=:83066
Content-Type: text/html; charset=us-ascii

<P>Hi Everybody,</P>
<P>How can I return multiple rows from a plpqsql function. I wanted to write a function which gives me the result of&nbsp;the final&nbsp;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.</P>
<P>Thanks,</P>
<P>Tarun</P><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
--0-595128334-1045512433=:83066--