NONE(...)

All functions > ARRAY > NONE(...)

Returns TRUE if no elements in the boolean array are true.

Syntax

NONE(value, value, ...)

NONE(value, value, ...)

Notes

• Returns TRUE for empty arrays (vacuous truth)
• Returns TRUE if all elements are false
• Equivalent to NOT ANY(array)
• NULL values in array will result in NULL return value

See also

• Array functions

Examples

SELECT
    -- Contains true
    f1 := NONE(TRUE, TRUE, TRUE),
    -- Contains true
    f2 := NONE(TRUE, FALSE, TRUE),
    -- No true elements
    f3 := NONE(FALSE, FALSE, FALSE)
;