SQL · Aggregate functions

bool_and() / bool_or()

True when every or any row matches. PostgreSQL; SQLite uses min()/max() on 0 and 1.

sqlRunnable example sql course

Syntax

bool_and(condition)

Example

Open in the lab

-- PostgreSQL: SELECT bool_and(published) FROM lessons;
WITH lessons(published) AS (VALUES (1), (1))
SELECT min(published) AS all_published FROM lessons;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

bool_and() / bool_or()

Example

More in this group

Learn this in the course