ANY

All functions > ARRAY > ANY

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

Syntax

Diagram(
  Sequence(
    Terminal("ANY"),
    Terminal("("),
    NonTerminal("value"),
    Terminal(","),
    OneOrMore(NonTerminal("value"), Terminal(",")),
    Terminal(")"),
  )
)

Notes

• Returns NULL for empty arrays
• Returns TRUE if at least one element is true
• NULL values in array will result in NULL return value

Examples

SELECT
    f1 := ANY(true, true, true),  -- Contains true
    f2 := ANY(true, false, true),  -- At least one true
    f3 := ANY(false, false, false)  -- No true elements
;