string_agg

Concatenates the non-null input values into a string. Each value after the first is preceded by the corresponding delimiter (if it's not null).

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

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

Concatenates the non-null input values into a string. Each value after the first is preceded by the corresponding delimiter (if it's not null).

Signatures and overloads

string_agg ( value text, delimiter text ) → text → text

Concatenates the non-null input values into a string. Each value after the first is preceded by the corresponding delimiter (if it's not null).

string_agg ( value bytea, delimiter bytea ORDER BY input_sort_columns ) → bytea → bytea

Concatenates the non-null input values into a string. Each value after the first is preceded by the corresponding delimiter (if it's not 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:6f313671df965c2e3f3c409ad4762d94851e8a78c0a71c9caca4c0b972ec28ef

Text language: en · wiki-repair-20261023:6f313671df965c2e3f3c409ad4762d94851e8a78c0a71c9caca4c0b972ec28ef