Logical disjunction. | |
Logical conjunction. | |
Logical negation. | |
Comparison operators. |
Logical disjunction.
db>
SELECT false OR true;
{true}
Logical conjunction.
db>
SELECT false AND true;
{false}
Logical negation.
db>
SELECT NOT false;
{true}
The AND
and OR
operators are commutative.
The truth tables are as follows:
a |
b |
a AND b |
a OR b |
NOT a |
---|---|---|---|---|
true |
true |
true |
true |
false |
true |
false |
false |
true |
false |
false |
true |
false |
true |
true |
false |
false |
false |
false |
true |