PostgreSQL – ARRAY_APPEND Function

ByAdmin

The array_append function in PostgreSQL is used to append an element to the end of an array. It takes two arguments: the array to which you want to append an element, and the element you want to append.

Below is the syntax of the array_append function:

array_append(array, element_to_append)

Where:

array is the array to which you want to append an element.

element_to_append is the element you want to append to the array.

Here’s an example of using the array_append function:

SELECT array_append('{10, 20, 30}', 40) AS result_array;

The output would be:

result_array 
-------------- 
{10,20,30,40} 
(1 row)

In this example, the array_append function appended the value 40 to the end of the input array.

Here is another example of using the array_append function: Consider a table named cart with an array column items and you want to add a new item to all rows:

UPDATE cart 
SET items = array_append(items, 'new_item') 
WHERE some_condition;

This query will update the items arrays in the cart table, appending 'new_item' to each array that meets the specified condition.

Similar Posts

PostgreSQL – ARRAY_LENGTH Function

ByAdmin

The array_length function is used to determine the length (number of elements) of a one-dimensional array in PostgreSQL. This function takes two arguments – the array and the dimension for which you want to find the length. Here’s the syntax of the array_length function: array_length(array_expression, dimension) Where: array_expression is the array for which you want…

PostgreSQL – STRING_TO_ARRAY Function

ByAdmin

The string_to_array function is used to split a string into an array of substrings based on a specified delimiter. It takes a string as input and returns an array of text elements as output. Below is the syntax for the string_to_array function: string_to_array(input_string, delimiter) where input_string is the string that you want to split into…