X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 14CBB47607B
	for <pgsql-sql@postgresql.org>; Thu,  6 Feb 2003 18:09:34 -0500 (EST)
Received: from post.webmailer.de (natsmtp01.webmailer.de [192.67.198.81])
	by postgresql.org (Postfix) with ESMTP id 3D4CA476417
	for <pgsql-sql@postgresql.org>; Thu,  6 Feb 2003 17:54:24 -0500 (EST)
Received: from ianb.local (pD95177A3.dip.t-dialin.net [217.81.119.163])
	by post.webmailer.de (8.9.3/8.8.7) with ESMTP id XAA15937;
	Thu, 6 Feb 2003 23:54:17 +0100 (MET)
Content-Type: text/plain;
  charset="iso-8859-1"
From: Ian Barwick <barwick@gmx.net>
To: "mail.luckydigital.com" <james.cooper@luckydigital.com>,
	<pgsql-sql@postgresql.org>
Subject: Re: 7.2 functions that return multiple result sets?
Date: Thu, 6 Feb 2003 23:53:55 +0100
X-Mailer: KMail [version 1.4]
References: <01ac01c2cb04$6af0aa20$c900a8c0@jax>
In-Reply-To: <01ac01c2cb04$6af0aa20$c900a8c0@jax>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200302062353.55824.barwick@gmx.net>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/134
X-Sequence-Number: 11532

On Sunday 02 February 2003 22:45, mail.luckydigital.com wrote:
> Can some one please confirm( with a plpgsql function example please ) a
> postgres "7.2" function that can return multiple rows to the client.
>
> I've gone through the docs and can't find anything to support this -it
> seems you can only have one return value or null.
>
> Yes i'm aware this it is possible in 7.3 - can someone please confirm its
> not possible in 7.2 or provide me with an example of how to go about it.

IIRC this is a new feature in 7.3, see:

http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D0&file=3Drelea=
se.html

"Allow functions to return multiple rows (table functions) (Joe)"

Ian Barwick
barwick@gmx.net