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

Re: SQL-Invoked Procedures for 8.1

From: Joe Conway <mail(at)joeconway(dot)com>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>,Oliver Jowett <oliver(at)opencloud(dot)com>,Grant Finnemore <grantf(at)guruhut(dot)co(dot)za>,pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL-Invoked Procedures for 8.1
Date: 2004-09-24 15:08:15
Message-ID: 4154385F.4090109@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Neil Conway wrote:
> On Fri, 2004-09-24 at 01:56, Joe Conway wrote:
> 
>>As other's have pointed out, this is very common in the MS SQL Server 
>>world (and I believe Sysbase also supports it).
> 
>>From looking at the docs, it appears this isn't supported by Oracle or
> DB2 (correct me if I'm wrong). I can see how it would be useful, but I
> don't think it needs to be part of the first shot at doing stored
> procedures.

I believe you are correct for Oracle at least.

But for people porting over from MSSQL it is a *huge* deal, and given 
the native windows port of Postgres with 8.0.0, I predict *many* 
requests for this in upcoming months.

Joe

In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2004-09-24 15:15:22
Subject: Re: SQL-Invoked Procedures for 8.1
Previous:From: Tom LaneDate: 2004-09-24 14:54:12
Subject: Re: planner & target lists

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