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...
That's probably not a very usual way of programming but we did it and
experienced problems for porting....
Regards,
Patrick
----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------
-----Original Message-----
From: Tino Wildenhain [mailto:tino@wildenhain.de]
Sent: vendredi 7 janvier 2005 12:08
To: Patrick FICHE
Cc: Craig Bryden; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Books for experienced DB developer
On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote:
> I'm afraid this is still a problem.
> From my knowledge, Postgres function is able to return a single result-set
> not multiple.
> I may have missed some facility...
<rtfm_please> see
http://techdocs.postgresql.org/guides/SetReturningFunctions
<rtfm_please> or
http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835
(fresh from freenode irc #postgresql channel)
Or is it not what you mean?
Regards
Tino
