JSON

JSONB_BUILD_ARRAY

PostgreSQL

Membuat JSON array dari nilai-nilai. Values bisa tipe apapun dan akan dikonversi ke JSON.

Tipe hasil: jsonb

Syntax

SQL

JSONB_BUILD_ARRAY(value1, value2, ...)

valuesanywajib

Nilai-nilai yang akan menjadi elemen array

SQL

1 SELECT JSONB_BUILD_ARRAY(1, two, 3.0, true, null);

Membuat JSON array dari berbagai tipe.

Hasil

jsonb_build_array
[1, "two", 3.0, true, null]

SQL

1 SELECT JSONB_BUILD_ARRAY(
2   JSONB_BUILD_OBJECT(id, 1, name, Item 1),
3   JSONB_BUILD_OBJECT(id, 2, name, Item 2)
4 );

Membuat array berisi objects.

Hasil

jsonb_build_array
[{"id": 1, "name": "Item 1"}, {"id": 2, ...}]

SQL

1 SELECT JSONB_BUILD_ARRAY(
2   (SELECT name FROM users WHERE id = 1),
3   (SELECT name FROM users WHERE id = 2)
4 ) AS user_names;

Menggunakan subquery sebagai elemen array.

JSON_ARRAY

MySQL

ARRAY_CONSTRUCT

Snowflake

JSON_ARRAY

BigQuery

JSON_ARRAY

DuckDB

1	SELECT JSONB_BUILD_ARRAY(
2	JSONB_BUILD_OBJECT(id, 1, name, Item 1),
3	JSONB_BUILD_OBJECT(id, 2, name, Item 2)
4	);

1	SELECT JSONB_BUILD_ARRAY(
2	(SELECT name FROM users WHERE id = 1),
3	(SELECT name FROM users WHERE id = 2)
4	) AS user_names;