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);
手册:
如果至少一个输入值是true,则为true,否则为false
如果任何源列为true,则将布尔值聚合为true
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);
手册:
如果至少一个输入值是true,则为true,否则为false