From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
Cc: | "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: proposal for 8.4: PL/pgSQL - statement CASE |
Date: | 2008-01-17 16:39:23 |
Message-ID: | 162867790801170839u77ac0050p6a0d3a6aa4f4658@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 17/01/2008, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Thu, 2008-01-17 at 16:01 +0100, Pavel Stehule wrote:
>
> > I found so PL/SQL support CASE statement
> > http://download-east.oracle.com/docs/cd/B10500_01/appdev.920/a96624/04_struc.htm#484
> >
> > I propose add this statement to PL/pgSQL too.
>
> Please don't post links to potentially copyrighted works.
I am sorry.
correct link http://www.pgsql.cz/index.php/Condition_statements
>
> We don't want things just because Oracle has them, we want them for a
> real reason. If say, you had a migration project that would be made
> easier by that feature, or there was clear benefit in improving the
> language through the addition of a feature, maybe. If not, we must try
> to do something better than everybody else, not just the same, unless
> its an official standard.
I understand well. But I would to respect similarity with PL/SQL. I
don't see reason for new special language for stored procedures that
is available only on PostgreSQL. And in this case Oracle PL/SQL CASE
statement is implementation of SQL/PSM CASE statement. Still SQL/PSM
isn't main language in PostgreSQL and isn't reason for fixation
plpgsql.
>
> I'd be interested in hearing about how SQL/PSM is going. What are your
> plans for that?
>
I prepare rpm and sources for 8.3 available from my archive and from
Devrim repository. There still some unsupported points - PostgreSQL
doesn't support all OOP features and some but not important things
depend on it (but I am not able to implement 100% clean SQL/PSM). And
than I will wait. Queue is full and I see lot of things with higher
priority than is SQL/PSM. I would to see real stored procedures in
8.4, but I don't belive.
Pavel
> --
> Simon Riggs
> 2ndQuadrant http://www.2ndQuadrant.com
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2008-01-17 16:40:51 | Re: proposal for 8.4: PL/pgSQL - statement CASE |
Previous Message | Joshua D. Drake | 2008-01-17 16:38:41 | Re: proposal for 8.4: PL/pgSQL - statement CASE |