You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2014/05/02 16:43:00 UTC
svn commit: r1591933 - /db/derby/docs/trunk/src/ref/rrefcase.dita
Author: chaase3
Date: Fri May 2 14:43:00 2014
New Revision: 1591933
URL: http://svn.apache.org/r1591933
Log:
DERBY-6560 Reference manual says ELSE clause is required in CASE expressions
Modified a Reference Manual topic.
Patch: DERBY-6560.diff
Modified:
db/derby/docs/trunk/src/ref/rrefcase.dita
Modified: db/derby/docs/trunk/src/ref/rrefcase.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcase.dita?rev=1591933&r1=1591932&r2=1591933&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcase.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcase.dita Fri May 2 14:43:00 2014
@@ -32,11 +32,13 @@ on a boolean test.</p> <codeblock><b>CAS
href="rrefsqlj23075.dita#rrefsqlj23075">booleanExpression</xref></i> THEN <i>thenExpression</i>
[ WHEN <i><xref
href="rrefsqlj23075.dita#rrefsqlj23075">booleanExpression</xref></i> THEN <i>thenExpression</i> ]*
- ELSE <i>elseExpression</i>
+ [ ELSE <i>elseExpression</i> ]
END</b></codeblock> <p>The <i>thenExpression</i> and <i>elseExpression</i> are
both expressions that must be type-compatible. For built-in types, this means
that the types must be the same or that a built-in broadening conversion must
-exist between the types.</p></refsyn>
+exist between the types.</p>
+<p>If an ELSE clause is not specified, ELSE NULL is implicit.</p>
+</refsyn>
<example><title>Example</title><codeblock><b>-- returns 3
VALUES CASE WHEN 1=1 THEN 3 ELSE 4 END