SQL · Array and set-returning functions

array_append()

Returns a new array with a value appended. PostgreSQL.

sqlRunnable example sql course

Syntax

array_append(array, value)

Example

Open in the lab

-- PostgreSQL
-- SELECT array_append(ARRAY[1,2], 3);

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.