Functions / Array Functions And Operators

array_remove

Removes all elements equal to the given value from the array.

Reading PG 18current·documented in 15 of 27 versions, 9.3 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

array_remove ( anycompatiblearray, anycompatible ) → 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.

array_remove(ARRAY[1,2,3,2], 2) → {1,3}

Version history 3

13 → 14 changed
12 → 13 changed
9.2 → 9.3 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source