w3resource

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

Code:

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

Sample Output:

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

Previous: TRUNC function
Next: ARRAY_CAT function



Follow us on Facebook and Twitter for latest update.