From: | "Sim Zacks" <sim(at)nospam(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Books for experienced DB developer |
Date: | 2005-01-10 14:02:05 |
Message-ID: | cru1vp$1a39$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2005-01-10 14:14:57 | Re: Transaction size |
Previous Message | Florian G. Pflug | 2005-01-10 13:58:24 | Re: Problem creating trigger-function with arguments (8.0rc4) |