Re: [GENERAL] Support for functions returning mutliple result sets?

2004-01-22 Thread Tom Lane
<[EMAIL PROTECTED]> writes: > Does postgres support returning multiple sets from a function? Not directly. You can fake it in some cases by returning several open cursors and expecting the caller to fetch from those cursors. However, if you can't write SQL queries that can be executed to return

Re: [GENERAL] Support for functions returning mutliple result sets?

2004-01-22 Thread Joe Conway
[EMAIL PROTECTED] wrote: I know I can write plpgsql functions that return sets. Does postgres support returning multiple sets from a function? No. Joe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[GENERAL] Support for functions returning mutliple result sets?

2004-01-22 Thread bill.postgresql-users
I know I can write plpgsql functions that return sets. Does postgres support returning multiple sets from a function? Bill McMilleon ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-no