How to aggregate boolean column

Question

How can I aggregate some tuples like this

COL_1 | COL_2 | COL_3 | COL_4  val  |   T   |   F   |   F  val  |   F   |   T   |   F 

with the OR function and return the following table?

COL_1 | COL_2 | COL_3 | COL_4  val  |   T   |   T   |   F 

Answer 1

Simply do a GROUP BY, use MAX() to return T if available, else F.

select col_1, max(col_2), max(col_3), max(col_4) from tablename group by col_1 

Answer 2

Just as a side note (doesn't work with Oracle): In PostgreSQL, you would do this:

SELECT col_1, bool_or(col_2), bool_or(col_3), bool_or(col_4) FROM tablename GROUP BY col_1 ORDER BY col_1