select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / ARRAY FUNCTIONS AND OPERATORS

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

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
  1. PG 13 → 14changed
  2. PG 12 → 13changed
  3. PG 9.2 → 9.3added

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