8

I have following set of table:

id   column_a  column_b   column_c
1     t          f           t
2     t          f           f
3     f          t           f

Which when queried by:

SELECT bool_or(column_a) AS column_a
     , bool_or(column_b) AS column_b
     , bool_or(column_c) AS column_c
FROM   tbl
WHERE  id IN (1,2);

gives result as:

column_a   column_b   column_c
 t          f            t

I wanted to get the array from the result as: [t,f,t] in Postgres.

Please have reference to the earlier stack question over here.

1 Answer 1

8

Use an ARRAY constructor:

SELECT ARRAY [bool_or(column_a)
            , bool_or(column_b)
            , bool_or(column_c)] AS arr_abc
FROM   tbl
WHERE  id IN (1,2);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.