Get logical result of boolean columns in several rows

Question

If I have a column which store boolean values, how can I apply OR operator over several rows of that column? I hope I don't have to use joins.

user_5288071 · Answer

You can use postgres aggregate functions for this, specifically bool_or and bool_and aggregate functions

create table bools (
  a boolean
);

insert into bools values(true), (true), (false);

select bool_or(a) from bools;