NONE

All functions > ARRAY > NONE

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

Syntax

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

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

Examples

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