Aggregate

BOOL_OR

PostgreSQL

Mengembalikan TRUE jika minimal satu nilai input adalah TRUE. Mengembalikan FALSE hanya jika semua nilai FALSE. Berguna untuk mengecek ada tidaknya kondisi tertentu dalam grup.

Tipe hasil: boolean

Syntax

SQL

BOOL_OR(expression)

Parameter

expressionbooleanwajib

Ekspresi boolean yang akan di-aggregate

Contoh Penggunaan

Cek Ada Task Urgent

SQL

1 SELECT 
2   project_id,
3   BOOL_OR(is_urgent) AS has_urgent_tasks
4 FROM tasks
5 GROUP BY project_id;

Mengecek apakah ada task urgent dalam project.

Hasil

project_id	has_urgent_tasks
1	true
2	false

Deteksi Error dalam Batch

SQL

1 SELECT 
2   batch_id,
3   BOOL_OR(has_error) AS batch_has_errors
4 FROM processing_logs
5 GROUP BY batch_id;

Mengecek apakah ada error dalam setiap batch processing.

Hasil

batch_id	batch_has_errors
101	false
102	true

Filter Customer dengan Complain

SQL

1 SELECT customer_id
2 FROM orders
3 GROUP BY customer_id
4 HAVING BOOL_OR(has_complaint) = true;

Mencari customer yang pernah mengajukan komplain.

Fungsi Equivalen di Database Lain

BOOLOR_AGG

Snowflake

LOGICAL_OR

BigQuery

BOOL_OR

DuckDB

Fungsi Terkait

BOOL_ANDEVERY

Kembali ke PostgreSQL Functions

1	SELECT
2	project_id,
3	BOOL_OR(is_urgent) AS has_urgent_tasks
4	FROM tasks
5	GROUP BY project_id;

1	SELECT
2	batch_id,
3	BOOL_OR(has_error) AS batch_has_errors
4	FROM processing_logs
5	GROUP BY batch_id;

1	SELECT customer_id
2	FROM orders
3	GROUP BY customer_id
4	HAVING BOOL_OR(has_complaint) = true;