Home > mailing lists

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

From	mail.luckydigital.com
Subject	7.2 functions that return multiple result sets?
Date	February 6, 2003 16:40:36
Msg-id	01ac01c2cb04$6af0aa20$c900a8c0@jax Whole thread Raw
Responses	Re: 7.2 functions that return multiple result sets? (Ian Barwick <barwick@gmx.net>)
List	pgsql-sql

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.

Thank you.

From: jasiek@serwer.skawsoft.com.pl
Date: 06 February 2003, 16:40:33
Subject: Re: How to return records from a function

From: Vicente Alabau Gonzalvo
Date: 06 February 2003, 16:40:38
Subject: numeric when compared to literal