ARRAY APPEND Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

PostgreSQL ARRAY_APPEND() function

ARRAY_APPEND() function

This function is used to append an element to the end of an array.

Syntax :

array_append (anyarray, anyelement)

Return Type :

anyarray

PostgreSQL Version : 9.3

Example : PostgreSQL ARRAY_APPEND() function

SELECT array_append(ARRAY[2,9], 6);

Output :

 array_append
--------------
 {2,9,6}
(1 row)