Re: Books for experienced DB developer - Mailing list pgsql-general

On Fri, 2005-01-07 at 12:17 +0100, Patrick FICHE wrote:
> No, this is only one result-set.
> MS SQL Server is able to return multiple result-set.
>
> For example, one SQL Server function can return the result of the following
> queries :
> SELECT * FROM Table1
> SELECT * FROM Table2
> SELECT * FROM Table3
>
> with Table1, Table2 and Table3 having different structures...
>
> For example, you can navigate in the result-sets in ODBC using the
> SQLMoreResults function...

I wonder how this fits into the SQL standard by any way ;)
Nevertheless you should be able to return 3 cursors you
define in your stored function and use them afterwards.

Regards
Tino