Re: Books for experienced DB developer

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(at)wildenhain(dot)de> wrote in message
news:1105096058(dot)4978(dot)62(dot)camel(at)sabrina(dot)peacock(dot)de(dot)(dot)(dot)
> 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
>