Aggregates Aggregate

bool_or()

Returns TRUE if any input value is TRUE, otherwise FALSE.

Arguments & returns

Aggregate

Overload link	`arg`	Returns
#01	`BOOLEAN`	`BOOLEAN`

SELECT bool_or(A)
FROM (VALUES
  (TRUE),
  (FALSE),
  (NULL)
) AS sample("A");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

SELECT BOOLOR_AGG(c1), BOOLOR_AGG(c2) FROM test

In DuckDB

SELECT BOOL_OR(CAST(c1 AS BOOLEAN)), BOOL_OR(CAST(c2 AS BOOLEAN)) FROM test