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 p
On Fri, Jan 07, 2005 at 12:20:13PM +0100, Tino Wildenhain wrote:
> Nevertheless you should be able to return 3 cursors you
> define in your stored function and use them afterwards.
A function can also return SETOF RECORD. However, a query calling
such a function would need to provide a column de
ql.org
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: [GENERAL] Books
for experienced DB dev
Michael Fuhr <[EMAIL PROTECTED]>
To: Craig Bryden <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Books for experienced DB developer
Date: Fri, 7 Jan 2005 02:58:29 -0700
On Fri, Jan 07, 2005 at 11:33:52AM +0200, Craig Bryden wrote:
> I am a very experience
Craig Bryden wrote:
Hi
I am a very experienced MS-SQL developer. I am looking to port a
database to PostgreSQL. Which books that are available would be ideal
for someone who is already an experienced DB developer?
If you are experienced, I'd say you'd save yourself some cash and be
perfectly fin
On Fri, 2005-01-07 at 12:17 +0100, Patrick FICHE wrote:
> 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 * FRO
MAIL PROTECTED]
> tél : 01 69 29 36 18
>
> ---
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Tino Wildenhain
> Sent: vendredi 7 janvier 2005 11:45
> To: Patrick FICHE
> Cc: Craig Bryden; p
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-se
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...
see
http://techdocs.postgresql.org/guides/SetReturningFunctions
or
http:
FICHE
Cc: Craig Bryden; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Books for experienced DB developer
On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote:
> Hi Craig,
>
> 2 years ago, I had to do some porting from MS SQL to Postgres.
> All the application logic was coded
On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote:
> Hi Craig,
>
> 2 years ago, I had to do some porting from MS SQL to Postgres.
> All the application logic was coded in stored procedures...
>
> The major problem I was faced to, was to port procedures returning multiple
> result-sets...
At
ECTED] Behalf Of Craig Bryden
Sent: vendredi 7 janvier 2005 11:04
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Books for experienced DB developer
Hi Michael
I am having some problems porting my Stored Procedures. I am using the
pl/pgsql language. Instead of irrit
too much time
explaining RDBMS basics.
Thanks
Craig
From: Michael Fuhr <[EMAIL PROTECTED]>
To: Craig Bryden <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Books for experienced DB developer
Date: Fri, 7 Jan 2005 02:58:29 -0700
On Fri, Jan 07, 2005 at 11:3
On Fri, Jan 07, 2005 at 11:33:52AM +0200, Craig Bryden wrote:
> I am a very experienced MS-SQL developer. I am looking to port a database
> to PostgreSQL. Which books that are available would be ideal for someone
> who is already an experienced DB developer?
PostgreSQL has good documentation so
14 matches
Mail list logo
