Re: 7.2 functions that return multiple result sets?

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(at)gmx(dot)net