NONE_FUNC
All functions > ARRAY > NONE_FUNC
Returns true if no elements in the boolean array are true.
Syntax
NONE_FUNC(array)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAYBOOLEAN | Yes | Array of boolean values to check |
Returns
BOOLEAN - true if all elements are false, false otherwise
Notes
- Returns true for empty arrays (vacuous truth)
- Returns true if all elements are false
- Equivalent to NOT ANY(array)
- Can be used with operator syntax: NONE(val1, val2, val3)
- NULL values in array will result in NULL return value
Aliases
ARRAY_NONE