document full syntax of CASE expression
---------------------------------------
Key: DERBY-1575
URL: http://issues.apache.org/jira/browse/DERBY-1575
Project: Derby
Issue Type: Improvement
Components: Documentation
Reporter: Christian d'Heureuse
The documentation at
http://db.apache.org/derby/docs/dev/ref/rrefcasenullif.html describes the CASE
expression syntax as:
CASE WHEN BooleanExpression THEN thenExpression ELSE elseExpression END
But the CASE expression supports more than one WHEN/THEN clauses.
I suggest to change the syntax description to:
CASE
WHEN BooleanExpression THEN Expression
[ WHEN BooleanExpression THEN Expression ]
...
ELSE elseExpression
END
Example:
VALUES
CASE
WHEN 1 = 2 THEN 3
WHEN 4 = 5 THEN 6
ELSE 7
END
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
