| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Patrick FICHE <Patrick(dot)FICHE(at)AQSACOM(dot)COM> |
| Cc: | Craig Bryden <brydencraig(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Books for experienced DB developer |
| Date: | 2005-01-07 11:20:13 |
| Message-ID: | 1105096814.4978.65.camel@sabrina.peacock.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Алексей Ш. | 2005-01-07 11:29:00 | Get execution plan of dynamic query |
| Previous Message | Patrick FICHE | 2005-01-07 11:17:14 | Re: Books for experienced DB developer |