db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1591933 - /db/derby/docs/trunk/src/ref/rrefcase.dita
Date Fri, 02 May 2014 14:43:00 GMT
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
 



Mime
View raw message