Skip site navigation (1) Skip section navigation (2)

Re: SQL-Invoked Procedures for 8.1

From: Maarten Boekhold <boekhold(at)emirates(dot)net(dot)ae>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL-Invoked Procedures for 8.1
Date: 2004-09-24 07:31:51
Message-ID: 4153CD67.10400@emirates.net.ae (view raw or flat)
Thread:
Lists: pgsql-hackers

Joe Conway wrote:
> Gavin Sherry wrote:
> 
>> Do you have any idea about databases returning result sets from SQL
>> procedures (ie, not functions).
>>
> 
> As other's have pointed out, this is very common in the MS SQL Server 
> world (and I believe Sysbase also supports it). It works like:

And these databases also return a result status/value from the stored 
procedure. IIRC this result is limited to an int value.

Maarten

In response to

Responses

pgsql-hackers by date

Next:From: Peter MountDate: 2004-09-24 07:56:15
Subject: Re: SQL-Invoked Procedures for 8.1
Previous:From: Neil ConwayDate: 2004-09-24 06:34:44
Subject: Re: NOFIXADE / NOPRINTADE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group