Tino, Multiple recordsets means returning multiple setof results, not just one. As an example in a SQL Server Stored Procedure you can have the following in the same stored procedure: create proc getdata as select * from table1 select * from table2 go and it will return 2 resultsets. This is not possible in postgresql today. "Tino Wildenhain" <tino@xxxxxxxxxxxxx> wrote in message news:1105096058.4978.62.camel@xxxxxxxxxxxxxxxxxxxxx > 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 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
