Re: Proposal: real procedures again (8.4) - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Proposal: real procedures again (8.4)
Date
Msg-id 162867790710271433j7acfa43p12d5625bd78a9f3f@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: real procedures again (8.4)  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
Hello

three years ago was big discus about stored procedures. Three years
later postgresql does not support stored procedures. So instead of one
super big jump I would to do more small steps.

2007/10/27, Hannu Krosing <hannu@skype.net>:
> Ühel kenal päeval, L, 2007-10-27 kell 13:43, kirjutas Gregory Stark:
> > "Pavel Stehule" <pavel.stehule@gmail.com> writes:
> >
> > > Later:
> > > * procedure can manages transactions,
> >
> > Personally this is the only actual feature on the list that seems to have any
> > point to me.
>
> Same here.
>
> And I'd like it to have support for other PL's beside SQL and PL/PGSQL.
>
> > * procedure can be overloaded,
>
> How is this different from function overloading ?

Current functions can overload only with IN params, stored procedures
can be overloaded with OUT params too.

>
> > * procedure can not returns recordset or multi recordset,
>
> Why ?
>

next step,

Pavel

pgsql-hackers by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Opportunity for a Radical Changes in Database Software
Next
From: "Alvaro Herrera"
Date:
Subject: Re: [COMMITTERS] pgsql: Allow an autovacuum worker to be interrupted automatically when