Re: proposal for 8.4: PL/pgSQL - statement CASE - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: proposal for 8.4: PL/pgSQL - statement CASE
Date
Msg-id 478F7C37.6040205@dunslane.net
Whole thread Raw
In response to Re: proposal for 8.4: PL/pgSQL - statement CASE  (Josh Berkus <josh@agliodbs.com>)
List 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


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: proposal for 8.4: PL/pgSQL - statement CASE
Next
From: "Joshua D. Drake"
Date:
Subject: Re: proposal for 8.4: PL/pgSQL - statement CASE