{"Entry":{"collection":"func","key":"array-to-string","name":"array_to_string","aliases":[],"metadata":{"changed_in":["9.1"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"7.3","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"7.4"},{"descriptions_changed":true,"doc_overhaul":false,"from":"7.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"8.0"},{"descriptions_changed":true,"doc_overhaul":false,"from":"8.3","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"8.4"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":["array_to_string ( anyarray, text [, text] ) → text"],"removed":["array_to_string ( anyarray, text ) → text"]},"status":"changed","to":"9.1"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"14","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"15"}],"content_hash":"91067e46351fe34afe4150dfb25dd73121e81c720cc7654d9e829f74c3e09afb","derived_content_hash":"8151914205dd76dcb5d9c2b4265d619b3ce05429cccbcc15ad620805cfa9b4c5","first_version":"7.4","group":"array","group_label":"Array Functions And Operators","groups":["array"],"imported_at":"2026-09-27T17:57:28.88746+08:00","last_version":"20","name":"array_to_string","name_key":"array_to_string","position":19016,"present_in":["7.4","8.0","8.1","8.2","8.3","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"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"ce00efcc8960866a51d78b72f5e497781627d2aaafda493d74f5f19df691c225","repair":"wiki-repair-20261023"},"signature":"array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text","signature_count":1,"slug":"array-to-string","source_rev":"wiki-repair-20261023:bf872336644b9026cb463d7593c9aaa663fa759eba10ccade699221339fb418e","summary":"Converts each array element to its text representation, and concatenates those separated by the delimiter string.","summary_zh":""}},"Definition":{"Collection":"func","Key":"array-to-string","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"array-to-string","SourceRevision":"wiki-repair-20261023:bf872336644b9026cb463d7593c9aaa663fa759eba10ccade699221339fb418e","Facts":{"description":"Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.","description_html":"Converts each array element to its text representation, and concatenates those separated by the \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e string. If \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e is given and is not \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e, then \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e array entries are represented by that string; otherwise, they are omitted. See also \u003ca href=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e.","description_zh":"将每个数组元素转换为其文本表示，并将它们用 delimiter 字符串分隔连接起来。如果提供了 null_string 且不是 NULL，则 NULL 数组条目将用该字符串表示；否则将被省略。另请参见 string_to_array。","description_zh_html":"将每个数组元素转换为其文本表示，并将它们用 \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e 字符串分隔连接起来。如果提供了 \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e 且不是 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e，则 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 数组条目将用该字符串表示；否则将被省略。另请参见 \u003ca href=\"/zh/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e。","doc":{"anchor":"ARRAY-FUNCTIONS-TABLE","file":"functions-array.html","slug":"18"},"group":"array","group_label":"Array Functions And Operators","lang":"en","layout":"table-new","pages":["functions-array.html"],"prose_only":false,"signatures":[{"description":"Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.","description_html":"Converts each array element to its text representation, and concatenates those separated by the \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e string. If \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e is given and is not \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e, then \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e array entries are represented by that string; otherwise, they are omitted. See also \u003ca href=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e.","description_zh":"将每个数组元素转换为其文本表示，并将它们用 delimiter 字符串分隔连接起来。如果提供了 null_string 且不是 NULL，则 NULL 数组条目将用该字符串表示；否则将被省略。另请参见 string_to_array。","description_zh_html":"将每个数组元素转换为其文本表示，并将它们用 \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e 字符串分隔连接起来。如果提供了 \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e 且不是 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e，则 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 数组条目将用该字符串表示；否则将被省略。另请参见 \u003ca href=\"/zh/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e。","examples":[{"expr":"array_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*')","result":"1,2,3,*,5"}],"html":"\u003ccode class=\"function\"\u003earray_to_string\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003earray\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyarray\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text","zh_from":"same-version-pgdoc"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-array.html","sha256":"a25a0710e8f84e027ef945e85452074399887341e22d79542584f9c646b8f076"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"ARRAY-FUNCTIONS-TABLE","file":"functions-array.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"array-to-string","SourceDatabase":"center","Version":"18","Locale":"en","Title":"array_to_string","Summary":"Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.","BodyHTML":"Converts each array element to its text representation, and concatenates those separated by the \u003cem\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e string. If \u003cem\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e is given and is not \u003ccode\u003eNULL\u003c/code\u003e, then \u003ccode\u003eNULL\u003c/code\u003e array entries are represented by that string; otherwise, they are omitted. See also \u003ca href=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\" rel=\"nofollow\"\u003e\u003ccode\u003estring_to_array\u003c/code\u003e\u003c/a\u003e.","SourceRevision":"wiki-repair-20261023:bf872336644b9026cb463d7593c9aaa663fa759eba10ccade699221339fb418e","ContentHash":"d8620e0f8268bcd41c016181a96879863eb7f94a2d369c10c5ba2715a17659ba","Payload":{"description":"Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.","description_html":"Converts each array element to its text representation, and concatenates those separated by the \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e string. If \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e is given and is not \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e, then \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e array entries are represented by that string; otherwise, they are omitted. See also \u003ca href=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e.","signatures":[{"description":"Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.","description_html":"Converts each array element to its text representation, and concatenates those separated by the \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e string. If \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e is given and is not \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e, then \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e array entries are represented by that string; otherwise, they are omitted. See also \u003ca href=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e.","description_zh":"将每个数组元素转换为其文本表示，并将它们用 delimiter 字符串分隔连接起来。如果提供了 null_string 且不是 NULL，则 NULL 数组条目将用该字符串表示；否则将被省略。另请参见 string_to_array。","description_zh_html":"将每个数组元素转换为其文本表示，并将它们用 \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e 字符串分隔连接起来。如果提供了 \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e 且不是 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e，则 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 数组条目将用该字符串表示；否则将被省略。另请参见 \u003ca href=\"/zh/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e。","examples":[{"expr":"array_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*')","result":"1,2,3,*,5"}],"html":"\u003ccode class=\"function\"\u003earray_to_string\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003earray\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyarray\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text","zh_from":"same-version-pgdoc"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"13ecef03d4042f4ea1f7e257a8896049a72c4c772dc6cbfbfa956e046faf3d0b","Text":"array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text","Returns":"text","Payload":{"description":"Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.","description_html":"Converts each array element to its text representation, and concatenates those separated by the \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e string. If \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e is given and is not \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e, then \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e array entries are represented by that string; otherwise, they are omitted. See also \u003ca href=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e.","description_zh":"将每个数组元素转换为其文本表示，并将它们用 delimiter 字符串分隔连接起来。如果提供了 null_string 且不是 NULL，则 NULL 数组条目将用该字符串表示；否则将被省略。另请参见 string_to_array。","description_zh_html":"将每个数组元素转换为其文本表示，并将它们用 \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e 字符串分隔连接起来。如果提供了 \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e 且不是 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e，则 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 数组条目将用该字符串表示；否则将被省略。另请参见 \u003ca href=\"/zh/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e。","examples":[{"expr":"array_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*')","result":"1,2,3,*,5"}],"html":"\u003ccode class=\"function\"\u003earray_to_string\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003earray\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eanyarray\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\u003c/span\u003e ] ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text","zh_from":"same-version-pgdoc"}}],"Spellings":null,"SQLState":null,"Evidence":null}