ARRAY_NOT()

All functions > ARRAY > ARRAY_NOT()

Returns an array with inverted boolean values (logical NOT applied to each element).

Signatures

Returns: Array with each element inverted

ARRAY_NOT(array: ARRAY<BOOLEAN>) → ARRAY<BOOLEAN>

Notes

• Applies logical NOT to each element
• true becomes false, false becomes true
• Preserves array structure and order
• NULL values remain NULL

See also

• Array functions

Examples

SELECT
    f1 := ARRAY_NOT(ARRAY[true, false, true]), -- Invert boolean values
    f2 := ARRAY_NOT(ARRAY[false, false, false]), -- All false becomes all true
    f3 := ARRAY_NOT(ARRAY[true, true, true]), -- All true becomes all false
    f4 := ARRAY_NOT(ARRAY[]::BOOLEAN[]) -- Empty array
;