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 : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: Tino Wildenhain [mailto:[EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
