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