Re: Books for experienced DB developer
От | Patrick FICHE |
---|---|
Тема | Re: Books for experienced DB developer |
Дата | |
Msg-id | 1DC6C8C88D09D51181A40002A52869299A35FF@intranet обсуждение исходный текст |
Ответ на | Books for experienced DB developer ("Craig Bryden" <brydencraig@hotmail.com>) |
Ответы |
Re: Books for experienced DB developer
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: