Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <4DD56EA6.2060400@oracle.com>
Date: Thu, 19 May 2011 12:25:26 -0700
From: Rick Hillegas <rick.hillegas@oracle.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
 rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: CASE [expression] WHEN [expression] THEN [expression] END syntax
References: <BANLkTin9xc5r+hu79-TJ939Tenf6jYdSHA@mail.gmail.com>
In-Reply-To: <BANLkTin9xc5r+hu79-TJ939Tenf6jYdSHA@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 5/19/11 11:36 AM, Lukas Eder wrote:
> Hello,
>
> I was wondering about this for a while, as Derby seems to be the only
> RDBMS I know that does not support the "simple syntax" for CASE
> clauses:
>
> CASE [expression]
>    WHEN [expression] THEN [expression]
>    WHEN [expression] THEN [expression]
>    ...
>
> See also
> https://issues.apache.org/jira/browse/DERBY-1576
>
> I know that all of these RDBMS support it: DB2, H2, HSQLDB, MySQL,
> Oracle, Postgres, SQLite, SQL Server, Sybase.
>
> Are there any plans to implement that?
>
>
> Cheers
> Lukas
>
Hi Lukas,

I'm not aware of any plans in this area. You are welcome to vote for 
DERBY-1576.

Regards,
-Rick