Re: proposal for 8.4: PL/pgSQL - statement CASE

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Subject: Re: proposal for 8.4: PL/pgSQL - statement CASE
Date: 2008-01-17 16:03:03
Message-ID: 478F7C37.6040205@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus wrote:
> Pavel,
>
>
>> I propose add this statement to PL/pgSQL too.
>>
>
> Isn't there a danger of syntactical conflict with the SQL SELECT ... CASE
> statement?
>
> I'd love to have CASE in PL/pgSQL, but I always thought that stood in the way.
>

It should be possible to disambiguate them, I believe.

You might find that a CASE statement does a little less than you expect,
though, if like the rest of PL/pgSQL it follows Ada rules.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2008-01-17 16:06:12 Re: proposal for 8.4: PL/pgSQL - statement CASE
Previous Message Josh Berkus 2008-01-17 15:49:17 Re: proposal for 8.4: PL/pgSQL - statement CASE