↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

array_replace

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

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

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

Definition PG 18

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

Signatures and overloads

array_replace ( anycompatiblearray, anycompatible, anycompatible ) → anycompatiblearray → anycompatiblearray
Replaces each array element equal to the second argument with the third argument.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

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

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