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 478F7E3E.3030004@dunslane.net
Whole thread Raw
In response to Re: proposal for 8.4: PL/pgSQL - statement CASE  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: proposal for 8.4: PL/pgSQL - statement CASE  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers

Joshua D. Drake wrote:
> 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.
>>
>
> Could it be called SWITCH instead?
>
>

That would surely defeat the whole point of having this. We want to have 
the same syntax as PL/SQL, not different syntax for the same things.

cheers

andrew


pgsql-hackers by date:

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