Comparison operators¶
These operations test whether two expressions are equal. Comparison Operators
result in a value of true
, false
or null
.
The following tables show the usual comparison operators that can be used for
all simple data types:
Operator | Description |
---|---|
< | less than |
> | greater than |
<= | less than or equal to |
>= | greater than or equal to |
= | equal |
<> | not equal |
!= | not equal - same as <> |
In addition, when the left operand is an IP and the right is text
that follows CIDR notation [ip address/prefix_length], the <<
operator can be used as in:
'192.160.0.1' << '192.160.0.0/24'
returning true when the IP is included in the range described by the CIDR.
If used in the WHERE clause the following operators are valid in addition.
Operator | Description |
---|---|
LIKE (ILIKE) | matches a part of the given value |
NOT | negates a condition |
IS NULL | matches a NULL value |
IS NOT NULL | matches a Non-NULL value |
~ | regular expression match |
!~ | negated regular expression match |
<< | IP is included in CIDR |
between | a BETWEEN x and y :
shortcut for a >= x AND a <= y |