array_agg

Collects all the input values, including nulls, into an array.

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

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

group: aggregate
group label: 聚合函数
lang: en
layout: table-new
pages: functions-aggregate.html
prose only: false

Definition PG 18

Collects all the input values, including nulls, into an array.

Signatures and overloads

array_agg ( anynonarray ORDER BY input_sort_columns ) → anyarray → anyarray

Collects all the input values, including nulls, into an array.

array_agg ( anyarray ORDER BY input_sort_columns ) → anyarray → anyarray

Concatenates all the input arrays into an array of one higher dimension. (The inputs must all have the same dimensionality, and cannot be empty or null.)

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-aggregate.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"31d3dcd36ef353484b4b3535f9f0d1cc239c3910146257fe5178f99b90b501e2","version":"18.7"},{"file":"functions-aggregate.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0bf7506d27b71666fc74840a21a8f77c8a92735174f1d05033865961722e457c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:153b8bed79598bb044da24325d0ceecc0e2e0963cb441844fbf7a5b22179d40f

Text language: en · wiki-repair-20261023:153b8bed79598bb044da24325d0ceecc0e2e0963cb441844fbf7a5b22179d40f