Not in list
Negated membership comparison.
Returns true when the left operand does not match any element in the right-hand list or array.
Category: comparison
SQL symbol: NOT IN
Example
SELECT b'0102' NOT IN ARRAY[1,2];
Signatures
blob NOT IN array→ booleanboolean NOT IN array→ booleandate NOT IN array→ booleandecimal NOT IN array→ booleandouble NOT IN array→ booleaninteger NOT IN array→ booleantimestamp NOT IN array→ booleanvarchar NOT IN array→ boolean
Types
- Left: blob, boolean, date, decimal, double, integer, timestamp, varchar
- Right: array
- Result: boolean