Array

ARRAY_PREPEND

PostgreSQL

Menambahkan element ke awal array. Perhatikan urutan parameter berbeda dengan ARRAY_APPEND.

Tipe hasil: anyarray

Syntax

SQL

ARRAY_PREPEND(element, array)

elementanywajib

Elemen yang akan ditambahkan ke awal

arrayanyarraywajib

Array sumber

SQL

1 SELECT ARRAY_PREPEND(0, ARRAY[1, 2, 3]);

Menambahkan 0 ke awal array.

Hasil

array_prepend
{0,1,2,3}

SQL

1 UPDATE task_queue
2 SET tasks = ARRAY_PREPEND(urgent_task, tasks)
3 WHERE queue_id = 1;

Menambahkan task urgent ke depan antrian.

SQL

1 SELECT 
2   ARRAY_PREPEND(first, ARRAY[a, b]) AS prepend,
3   ARRAY_APPEND(ARRAY[a, b], last) AS append;

Perbandingan prepend dan append.

Hasil

prepend	append
{first,a,b}	{a,b,last}

ARRAY_PREPEND

Snowflake

LIST_PREPEND

DuckDB

1	UPDATE task_queue
2	SET tasks = ARRAY_PREPEND(urgent_task, tasks)
3	WHERE queue_id = 1;

1	SELECT
2	ARRAY_PREPEND(first, ARRAY[a, b]) AS prepend,
3	ARRAY_APPEND(ARRAY[a, b], last) AS append;