db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r915031 - /db/derby/docs/trunk/src/ref/rrefsqlj23075.dita
Date Mon, 22 Feb 2010 19:34:16 GMT
Author: chaase3
Date: Mon Feb 22 19:34:16 2010
New Revision: 915031

URL: http://svn.apache.org/viewvc?rev=915031&view=rev
Log:
DERBY-4000: Reference manual leaves != out of list of boolean operators

Added a note to the entry in the boolean expressions table that describes these operators.

Patch: DERBY-4000.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefsqlj23075.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqlj23075.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj23075.dita?rev=915031&r1=915030&r2=915031&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj23075.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj23075.dita Mon Feb 22 19:34:16 2010
@@ -70,7 +70,9 @@
 <entry colname="2">&lt;, =, &gt;, &lt;=, &gt;=, &lt;&gt; are
applicable to
 all of the built-in types.   <codeblock><b>DATE('1998-02-26') &lt;
     DATE('1998-03-01')
-<ph>-- returns true</ph></b></codeblock></entry>
+<ph>-- returns true</ph></b></codeblock>
+<note><ph conref="../conrefs.dita#prod/productshortname"></ph> also accepts
+the != operator, which is not included in the SQL standard.</note></entry>
 <entry colname="3"> <codeblock><b><b><i>Expression</i></b>
 {
   &lt; |
@@ -100,7 +102,7 @@
 character expression.   <codeblock><b>city LIKE 'Sant_'</b></codeblock></p>
 <p>To
 treat % or _ as constant characters, escape the character with an optional
 escape character, which you specify with the ESCAPE clause.   <codeblock><b>SELECT
a FROM tabA WHERE a 
-LIKE '%=_' ESCAPE '='</b></codeblock></p><note>When LIKE comparisons
are used,<?Pub Caret?><ph
+LIKE '%=_' ESCAPE '='</b></codeblock></p><note>When LIKE comparisons
are used, <ph
 conref="../conrefs.dita#prod/productshortname"></ph> compares one character
 at a time for non-metacharacters. This is different than the way <ph conref="../conrefs.dita#prod/productshortname"></ph>
processes
 = comparisons. The comparisons with the = operator compare the entire character



Mime
View raw message