Skip to main content

BOOL_OR aggregate function

Returns true if at least one value in expr is true within the group.

Syntax

BOOL_OR( [DISTINCT] expr )

Arguments

  • expr: A BOOLEAN expression

Returns

A BOOLEAN.

Examples

> SELECT BOOL_OR(col) FROM (SELECT true AS col UNION ALL SELECT true UNION ALL SELECT true);
true

> SELECT BOOL_OR(col) FROM (SELECT NULL AS col UNION ALL SELECT true UNION ALL SELECT false);
true

> SELECT BOOL_OR(col) FROM (SELECT false AS col UNION ALL SELECT false UNION ALL SELECT false);
false

> SELECT BOOL_AND(DISTINCT col) FROM (SELECT true AS col UNION ALL SELECT false UNION ALL SELECT true);
true