db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: CASE [expression] WHEN [expression] THEN [expression] END syntax
Date Thu, 19 May 2011 19:25:26 GMT
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

Mime
View raw message