bool_or#
- bool_or(input)[source]#
Returns true if any non-null elements in the input expression are true, false if all are false, and null if all elements are null.
Example:
SQL#SELECT bool_or(x) FROM tbl
Input#╭─────────╮ │ x │ │ --- │ │ Boolean │ ╞═════════╡ │ false │ ├╌╌╌╌╌╌╌╌╌┤ │ true │ ├╌╌╌╌╌╌╌╌╌┤ │ null │ ╰─────────╯ (Showing first 3 of 3 rows)
Output#╭─────────╮ │ x │ │ --- │ │ Boolean │ ╞═════════╡ │ true │ ╰─────────╯ (Showing first 1 of 1 rows)