Aggregate

EVERY

PostgreSQL

Alias untuk BOOL_AND. Mengembalikan TRUE jika semua nilai input adalah TRUE. Nama EVERY lebih mudah dibaca dalam konteks query.

Tipe hasil: boolean

Syntax

SQL

EVERY(expression)

expressionbooleanwajib

Ekspresi boolean yang akan di-aggregate

SQL

1 SELECT 
2   customer_id,
3   EVERY(is_paid) AS all_paid
4 FROM invoices
5 GROUP BY customer_id;

Mengecek apakah semua invoice customer sudah dibayar.

Hasil

customer_id	all_paid
1	true
2	false

SQL

1 SELECT 
2   form_id,
3   EVERY(field_value IS NOT NULL) AS all_fields_filled
4 FROM form_submissions
5 GROUP BY form_id;

Mengecek apakah semua field required sudah diisi.

Hasil

form_id	all_fields_filled
101	true
102	false

SQL

1 SELECT 
2   EVERY(score >= 60) AS all_passed_every,
3   BOOL_AND(score >= 60) AS all_passed_bool
4 FROM exam_results
5 WHERE class_id = 1;

EVERY dan BOOL_AND menghasilkan hasil yang sama.

1	SELECT
2	form_id,
3	EVERY(field_value IS NOT NULL) AS all_fields_filled
4	FROM form_submissions
5	GROUP BY form_id;

1	SELECT
2	EVERY(score >= 60) AS all_passed_every,
3	BOOL_AND(score >= 60) AS all_passed_bool
4	FROM exam_results
5	WHERE class_id = 1;