log_exp - NOT
... NOT log_exp ...
The negation of a logical expression
NOT creates a new logical expression that is false if the logical expression
log_exp is true and vice versa.
- The operator
NOTis a stronger join than
- The Boolean operator
NOTmust not be confused with the addition
NOTof the relational operators
IN, and the predicate operator
IS. The following syntax is one possible example:
... NOT operand NOT IN seltab ...
NOTis a Boolean operator that negates a comparison expression. The second
NOTis a part of the comparison expression withe the relational operator
IN. This is made clear using parentheses around the comparison expression:
... NOT ( operand NOT IN seltab ) ...