Re: question about 8.1 and stored procedures

On Sun, 20 Mar 2005, Joshua D. Drake wrote:

> 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.

I mean original Josh's interview
"An example of what people are working on right now is SQL standard compliant
stored procedures. We have procedures now, but they're not compliant with the
standard syntax." Nothing about Oracle unless Oracle has standard compliant
stored procedures.

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

What's the difference between UDF and stored procedure ?

>
> 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
>
>
>
>

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