BOOL_OR

1
SELECT
2
  batch_id,
3
  BOOL_OR(has_error) as has_any_error
4
FROM batch_records
5
GROUP BY batch_id;

1
SELECT
2
  order_id,
3
  BOOL_OR(is_flagged) as needs_review,
4
  BOOL_OR(is_high_value) as has_high_value_item,
5
  SUM(amount) as total_amount
6
FROM order_items
7
GROUP BY order_id;

1
SELECT
2
  server_group,
3
  BOOL_OR(cpu_critical) as any_cpu_alert,
4
  BOOL_OR(memory_critical) as any_memory_alert,
5
  BOOL_OR(disk_critical) as any_disk_alert,
6
  CASE
7
    WHEN BOOL_OR(cpu_critical OR memory_critical OR disk_critical)
8
    THEN '🔴 ALERT'
9
    ELSE '🟢 OK'
10
  END as status
11
FROM server_metrics
12
WHERE timestamp > NOW() - INTERVAL '5 minutes'
13
GROUP BY server_group;