PostgreSQL array_remove() Function

The PostgreSQL array_remove() function removes all specified elements from the specified array and returns the modified array.

array_remove() Syntax

Here is the syntax of the PostgreSQL array_remove() function:

array_remove(array, element) -> array



Required. The array to remove the specified element from.


Required. The element to remove.

Return value

The PostgreSQL array_remove() function returns an array from which the specified element is removed.

The type of the element to be removed must be the same as the data type of the array, otherwise the array_remove() function will give an error message.

The array_remove() function will return NULL if the specified array is NULL.

array_remove() Examples

This example shows how to use the PostgreSQL array_remove() function to remove 2 from {1, 1, 2, 1, 2, 1, 2}.

SELECT array_remove(ARRAY[1, 1, 2, 1, 2, 1, 2], 2);