Re: Books for experienced DB developer

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(dot)fiche(at)aqsacom(dot)com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------

-----Original Message-----
From: Tino Wildenhain [mailto:tino(at)wildenhain(dot)de]
Sent: vendredi 7 janvier 2005 12:08
To: Patrick FICHE
Cc: Craig Bryden; pgsql-general(at)postgresql(dot)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