Below is the example and syntax of the array_cat function.Īrray_cat(Array1 (Any array element which was we have used with array_cat function), Array2 (Any array element which was we have used with array_cat function))Įxample SELECT array_cat(ARRAY, ARRAY) This array function is used to concatenate two arrays in PostgreSQL. Below is the example and syntax of the array_append function.Īrray_append(array ((Any_array)Any array element which was we have used with array_append function, element(Any element which was used with array_append function))Įxample SELECT array_append(array, 6) This array function is used to append the element with the end of the array. Hadoop, Data Science, Statistics & others PostgreSQL Array Functionsīelow is the array function which was available in PostgreSQL.īelow is the description of the array function in PostgreSQL.
