ANY(...)

All functions > ARRAY > ANY(...)

Returns TRUE if any element in the boolean array is true.

Syntax

ANY(value, value, ...)

ANY(value, value, ...)

Notes

• NULL elements are ignored
• Returns TRUE when any non-NULL element is TRUE
• Returns FALSE when every non-NULL element is FALSE
• An empty array is FALSE. An array whose elements are all NULL is FALSE, the empty set after the NULL skip

See also

• Array functions

Examples

RETURN
    -- Contains true
    f1 := ANY(TRUE, TRUE, TRUE),
    -- At least one true
    f2 := ANY(TRUE, FALSE, TRUE),
    -- No true elements
    f3 := ANY(FALSE, FALSE, FALSE)
;