array_remove

Removes all elements equal to the given value from the array. The array must be one-dimensional. Comparisons are done using IS NOT DISTINCT FROM semantics, so it is possible to remove NULLs.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: array
group label: Array Functions And Operators
lang: en
layout: table-new
pages: functions-array.html
prose only: false

Definition PG 18

Removes all elements equal to the given value from the array. The array must be one-dimensional. Comparisons are done using IS NOT DISTINCT FROM semantics, so it is possible to remove NULLs.

Signatures and overloads

array_remove ( anycompatiblearray, anycompatible ) → anycompatiblearray → anycompatiblearray

Removes all elements equal to the given value from the array. The array must be one-dimensional. Comparisons are done using IS NOT DISTINCT FROM semantics, so it is possible to remove NULLs.

Compare versions

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:bb46fc68c8e38f5fe45d36e4d49afbaabd98f6c294d463521953a30f808df781

Text language: en · wiki-repair-20261023:bb46fc68c8e38f5fe45d36e4d49afbaabd98f6c294d463521953a30f808df781