Re: SQL-Invoked Procedures for 8.1 - Mailing list pgsql-hackers

From Maarten Boekhold
Subject Re: SQL-Invoked Procedures for 8.1
Date
Msg-id 4153CD67.10400@emirates.net.ae
Whole thread Raw
In response to Re: SQL-Invoked Procedures for 8.1  (Joe Conway <mail@joeconway.com>)
Responses Re: SQL-Invoked Procedures for 8.1  (Peter Mount <peter@retep.org.uk>)
List 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


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: NOFIXADE / NOPRINTADE
Next
From: Peter Mount
Date:
Subject: Re: SQL-Invoked Procedures for 8.1