Re: SQL-Invoked Procedures for 8.1

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL-Invoked Procedures for 8.1
Date: 2004-09-24 09:32:41
Message-ID: 1096018361.25688.627.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Maarten Boekhold 2004-09-24 12:56:05 Re: SQL-Invoked Procedures for 8.1
Previous Message Neil Conway 2004-09-24 09:28:09 Re: SQL-Invoked Procedures for 8.1