Aggregate

BOOL_AND

PostgreSQL

Mengembalikan TRUE jika semua nilai input adalah TRUE. Mengembalikan FALSE jika ada minimal satu nilai FALSE. Berguna untuk validasi kondisi pada grup data.

Tipe hasil: boolean

Syntax

SQL

BOOL_AND(expression)

Parameter

expressionbooleanwajib

Ekspresi boolean yang akan di-aggregate

Contoh Penggunaan

Cek Semua Task Selesai

SQL

1 SELECT 
2   project_id,
3   BOOL_AND(is_completed) AS all_tasks_done
4 FROM tasks
5 GROUP BY project_id;

Mengecek apakah semua task dalam project sudah selesai.

Hasil

project_id	all_tasks_done
1	true
2	false

Validasi Data Quality

SQL

1 SELECT 
2   batch_id,
3   BOOL_AND(is_valid) AS batch_valid,
4   BOOL_AND(is_processed) AS batch_processed
5 FROM records
6 GROUP BY batch_id;

Mengecek validitas dan status processing per batch.

Hasil

batch_id	batch_valid	batch_processed
101	true	true
102	false	true

Filter Grup yang Memenuhi Syarat

SQL

1 SELECT project_id
2 FROM tasks
3 GROUP BY project_id
4 HAVING BOOL_AND(is_completed) = true;

Mencari project yang semua tasknya sudah selesai.

Fungsi Equivalen di Database Lain

BOOLAND_AGG

Snowflake

LOGICAL_AND

BigQuery

BOOL_AND

DuckDB

Fungsi Terkait

BOOL_OREVERY

Kembali ke PostgreSQL Functions

1	SELECT
2	project_id,
3	BOOL_AND(is_completed) AS all_tasks_done
4	FROM tasks
5	GROUP BY project_id;

1	SELECT
2	batch_id,
3	BOOL_AND(is_valid) AS batch_valid,
4	BOOL_AND(is_processed) AS batch_processed
5	FROM records
6	GROUP BY batch_id;

1	SELECT project_id
2	FROM tasks
3	GROUP BY project_id
4	HAVING BOOL_AND(is_completed) = true;