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
    f1 := NONE(true, true, true), -- Contains true
    f2 := NONE(true, false, true), -- Contains true
    f3 := NONE(false, false, false) -- No true elements
;