ARRAY_NOT
All functions > ARRAY > ARRAY_NOT
Returns an array with inverted boolean values (logical NOT applied to each element).
Syntax
ARRAY_NOT(array)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAYBOOLEAN | Yes | Array of boolean values to invert |
Returns
BOOLEAN[] - Array with each element inverted
Notes
- Applies logical NOT to each element
- true becomes false, false becomes true
- Preserves array structure and order
- NULL values remain NULL