db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Eder <lukas.e...@gmail.com>
Subject CASE [expression] WHEN [expression] THEN [expression] END syntax
Date Thu, 19 May 2011 18:36:08 GMT
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

Mime
View raw message