Array

CARDINALITY

PostgreSQL

Mengembalikan total jumlah elemen dalam array, termasuk semua dimensi. Untuk array multidimensi, menghitung total semua elemen.

Tipe hasil: integer

Syntax

SQL

CARDINALITY(array)

Parameter

arrayanyarraywajib

Array yang akan dihitung

Contoh Penggunaan

Cardinality Array 1D

SQL

1 SELECT CARDINALITY(ARRAY[1, 2, 3, 4, 5]);

Menghitung elemen dalam array 1 dimensi.

Hasil

cardinality
5

Cardinality vs ARRAY_LENGTH

SQL

1 SELECT 
2   CARDINALITY(ARRAY[[1,2], [3,4], [5,6]]) AS card,
3   ARRAY_LENGTH(ARRAY[[1,2], [3,4], [5,6]], 1) AS len_dim1,
4   ARRAY_LENGTH(ARRAY[[1,2], [3,4], [5,6]], 2) AS len_dim2;

CARDINALITY total elemen, ARRAY_LENGTH per dimensi.

Hasil

card	len_dim1	len_dim2
6	3	2

Filter by Element Count

SQL

1 SELECT name, tags
2 FROM products
3 WHERE CARDINALITY(tags) >= 3;

Mencari produk dengan minimal 3 tags.

Fungsi Equivalen di Database Lain

ARRAY_SIZE

Snowflake

ARRAY_LENGTH

BigQuery

ARRAY_LENGTH

DuckDB

Fungsi Terkait

ARRAY_LENGTHARRAY_DIMSARRAY_UPPERARRAY_LOWER

Kembali ke PostgreSQL Functions

1	SELECT
2	CARDINALITY(ARRAY[[1,2], [3,4], [5,6]]) AS card,
3	ARRAY_LENGTH(ARRAY[[1,2], [3,4], [5,6]], 1) AS len_dim1,
4	ARRAY_LENGTH(ARRAY[[1,2], [3,4], [5,6]], 2) AS len_dim2;

1	SELECT name, tags
2	FROM products
3	WHERE CARDINALITY(tags) >= 3;