Re: question about 8.1 and stored procedures

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, tony_caduto(at)amsoftwaredesign(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: question about 8.1 and stored procedures
Date: 2005-03-20 17:45:53
Message-ID: 423DB6D1.4090005@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oleg Bartunov wrote:

> On Sun, 20 Mar 2005, Bruce Momjian wrote:
>
>> Tony Caduto wrote:
>>
>>> Hi,
>>> I read in a article/interview on
>>> http://madpenguin.org/cms/html/62/3677.html
>>> that work was being done on improving/adding support for sql standard
>>> compliant stored procs/functions
>>>
>>> Does anyone know exactly what that means?
>>>
>>> Does it mean that Postgres will have stored procs that can have input
>>> and output params?
>>
>>
>> Yes.
>
>
> I think that keyword here is 'sql standard compliant', not stored
> procedures
> itself, because we have them for a long time and with support of dozen
> languages. Or I miss something ?

What I read from this is, when will PostgreSQL have stored procedures
like Oracle. Thus the IN/OUT parameter statement.

My understanding is that 8.1 will have a much more mature implementation of
stored procedures versus UDFs (Which we have had forever).

Sincerely,

Joshua D. Drake

>
>
>>
>>
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 285 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2005-03-20 17:57:44 Re: question about 8.1 and stored procedures
Previous Message Oleg Bartunov 2005-03-20 16:09:45 Re: question about 8.1 and stored procedures