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

From Neil Conway
Subject Re: SQL-Invoked Procedures for 8.1
Date
Msg-id 1096018361.25688.627.camel@localhost.localdomain
Whole thread Raw
In response to Re: SQL-Invoked Procedures for 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SQL-Invoked Procedures for 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, 2004-09-24 at 02:40, Tom Lane wrote:
> I concur with Grant Finnemore's objection as well: people expect
> procedures to be able to return resultsets, ie SETOF something,
> not only scalar values.

IMHO most products (and the standard) define stored procedures as not
returning _anything_, whether they be scalar values or not. The only
counter-example I've seen pointed out is MS SQL. Or are you talking
about non-scalar OUT params?

-Neil




pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: SQL-Invoked Procedures for 8.1
Next
From: Maarten Boekhold
Date:
Subject: Re: SQL-Invoked Procedures for 8.1