db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4000) Reference manual leaves != out of list of boolean operators
Date Tue, 30 Dec 2008 16:42:44 GMT
Reference manual leaves != out of list of boolean operators
-----------------------------------------------------------

                 Key: DERBY-4000
                 URL: https://issues.apache.org/jira/browse/DERBY-4000
             Project: Derby
          Issue Type: Improvement
          Components: Documentation
    Affects Versions: 10.5.0.0
            Reporter: Knut Anders Hatlen
            Priority: Minor


Table 1, SQL Boolean Operators, at <URL:http://db.apache.org/derby/docs/dev/ref/rrefsqlj23075.html>
lists the comparison operators <, =, >, <=, >=, <>. Derby also accepts !=,
which I believe has the same meaning as <>. The != operator should be documented along
with the other operators. (I haven't checked whether != is standard SQL.)

ij> select * from (values 1,2,3)v(x) where x != 2;
X          
-----------
1          
3          

2 rows selected
ij> select * from (values 1,2,3)v(x) where x <> 2;
X          
-----------
1          
3          

2 rows selected

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message