↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

array_fill

Returns an array filled with copies of the given value, having dimensions of the lengths specified by the second argument. The optional third argument supplies lower-bound values for each dimension (which default to all 1).

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

Returns an array filled with copies of the given value, having dimensions of the lengths specified by the second argument. The optional third argument supplies lower-bound values for each dimension (which default to all 1).

Signatures and overloads

array_fill ( anyelement, integer[] [, integer[] ] ) → anyarray → anyarray
Returns an array filled with copies of the given value, having dimensions of the lengths specified by the second argument. The optional third argument supplies lower-bound values for each dimension (which default to all 1).

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:874cb5a99087aab770617ae585e63f145681d8126cdf2d47e2e279be677b3dd9

Text language: en · wiki-repair-20261023:874cb5a99087aab770617ae585e63f145681d8126cdf2d47e2e279be677b3dd9