Re: 7.2 functions that return multiple result sets? - Mailing list pgsql-sql

From Ian Barwick
Subject Re: 7.2 functions that return multiple result sets?
Date
Msg-id 200302062353.55824.barwick@gmx.net
Whole thread Raw
In response to 7.2 functions that return multiple result sets?  ("mail.luckydigital.com" <james.cooper@luckydigital.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: numeric when compared to literal
Next
From: "Josh Berkus"
Date:
Subject: Re: Automatic casting