From: Ian Barwick <barwick@gmx.net>
To: mail.luckydigital.com <james.cooper@luckydigital.com>
To: pgsql-sql@postgresql.org
Subject: Re: 7.2 functions that return multiple result sets?
Date: Thu, 6 Feb 2003 23:53:55 +0100
Message-ID: <200302062353.55824.barwick@gmx.net> (raw)
In-Reply-To: <01ac01c2cb04$6af0aa20$c900a8c0@jax>
References: <01ac01c2cb04$6af0aa20$c900a8c0@jax>
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=7.3&idoc=0&file=release.html
"Allow functions to return multiple rows (table functions) (Joe)"
Ian Barwick
barwick@gmx.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: barwick@gmx.net, james.cooper@luckydigital.com
Subject: Re: 7.2 functions that return multiple result sets?
In-Reply-To: <200302062353.55824.barwick@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox