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
    -- Invert boolean values
    f1 := ARRAY_NOT(ARRAY(TRUE, FALSE, TRUE)),
    -- All false becomes all true
    f2 := ARRAY_NOT(ARRAY(FALSE, FALSE, FALSE)),
    -- All true becomes all false
    f3 := ARRAY_NOT(ARRAY(TRUE, TRUE, TRUE)),
    -- Empty array
    f4 := ARRAY_NOT(ARRAY()::BOOLEAN[])
;