w3resource logo

PostgreSQL logo

PostgreSQL ARRAY_APPEND() function

Secondary Nav

ARRAY_APPEND() function

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

Syntax :

array_append (anyarray, anyelement)

Return Type :


PostgreSQL Version : 9.3

Example : PostgreSQL ARRAY_APPEND() function

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

Output :

(1 row)

Join our Question Answer community to learn and share your programming knowledge.

Help the community:

PHP: Loop

JavaScript: Delete duplicates in an array

Oracle: Round the number