ALL

All functions > ARRAY > ALL

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

Syntax

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

Notes

• Returns NULL for empty arrays
• Returns FALSE if any element is false
• NULL values in array will result in NULL return value

Examples

SELECT
    f1 := ALL(true, true, true),  -- All true
    f2 := ALL(true, false, true),  -- Contains false
    f3 := ALL(false, false, false)  -- All false
;