Functions / Array Functions And Operators

array_replace

Replaces each array element equal to the second argument with the third argument.

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

Signatures & examples

array_replace ( anycompatiblearray, anycompatible, anycompatible ) → anycompatiblearray

Replaces each array element equal to the second argument with the third argument.

array_replace(ARRAY[1,2,5,4], 5, 3) → {1,2,3,4}

Version history 3

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