| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Hannu Krosing" <hannu(at)skype(dot)net> |
| Cc: | "Gregory Stark" <stark(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "Josh Berkus" <Josh(dot)Berkus(at)sun(dot)com>, "David Fetter" <david(at)fetter(dot)org> |
| Subject: | Re: Proposal: real procedures again (8.4) |
| Date: | 2007-10-27 21:33:34 |
| Message-ID: | 162867790710271433j7acfa43p12d5625bd78a9f3f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)skype(dot)net>:
> Ühel kenal päeval, L, 2007-10-27 kell 13:43, kirjutas Gregory Stark:
> > "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-10-27 22:15:12 | Re: Autovacuum cancellation |
| Previous Message | Hannu Krosing | 2007-10-27 21:20:47 | Re: [PATCHES] Including Snapshot Info with Indexes |