Logical Operators

Logical operators are used to operate on one or more operands and return a boolean result.

Syntax

 
    select * from ...
    where expression1 and  expression2
     
    select * from ...
    where expression1 or expression2
     
    select * from ...
    where not expression1
     

The eXtremeSQL logical operators are the following:

and	True if both expressions are true
or	True if one or both of the expressions is true
not	True if the expression is false

These logical operators can also be used to perform bitwise operations. Please see the Bitwise Operations page for further details.

Examples

 
    select 1 < 2 and 2 > 3;
    #1
    ------------------------------------------------------------------------------
    false
 
    Selected records: 1
     
    select 1 < 2 or 2 > 3;
    #1
    ------------------------------------------------------------------------------
    true
 
    Selected records: 1
     
    create table t(i integer, d date);
    insert into t values([3,5],['2017-01-01','2017-02-01']);
     
    select * from t where not i = 2;
    i       d
    ------------------------------------------------------------------------------
    3       01/01/2017 00:00:00
    5       02/01/2017 00:00:00
 
    Selected records: 2