{"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","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"],"signature":"array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text","signature_count":1,"slug":"array-to-string","source_rev":"b7bd9cda","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":"b7bd9cda","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":"","description_zh_html":"","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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"ARRAY-FUNCTIONS-TABLE","file":"functions-array.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"array-to-string","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"array_to_string","Summary":"将每个数组元素转换为其文本表示，并将它们用delimiter字符串分隔连接起来。如果提供了null_string且不是NULL，则NULL数组条目将用该字符串表示；否则将被省略。另请参见string_to_array。","BodyHTML":"将每个数组元素转换为其文本表示，并将它们用\u003cem\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e字符串分隔连接起来。如果提供了\u003cem\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e且不是\u003ccode\u003eNULL\u003c/code\u003e，则\u003ccode\u003eNULL\u003c/code\u003e数组条目将用该字符串表示；否则将被省略。另请参见\u003ca href=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\" rel=\"nofollow\"\u003e\u003ccode\u003estring_to_array\u003c/code\u003e\u003c/a\u003e。\u003cpre\u003earray_to_string ( array anyarray, delimiter text [, null_string text ] ) → text\u003c/pre\u003e将每个数组元素转换为其文本表示，并将它们用\u003cem\u003e\u003ccode\u003edelimiter\u003c/code\u003e\u003c/em\u003e字符串分隔连接起来。如果提供了\u003cem\u003e\u003ccode\u003enull_string\u003c/code\u003e\u003c/em\u003e且不是\u003ccode\u003eNULL\u003c/code\u003e，则\u003ccode\u003eNULL\u003c/code\u003e数组条目将用该字符串表示；否则将被省略。另请参见\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":"1b5ca64c","ContentHash":"7a2f0a5319c85dcfce3f5387d656f8741bb52e9844b0002e71fb0c507afb10c2","Payload":{"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=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e。","signatures":[{"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=\"/docs/18/functions-string.html#FUNCTION-STRING-TO-ARRAY\"\u003e\u003ccode class=\"function\"\u003estring_to_array\u003c/code\u003e\u003c/a\u003e。","returns":"text","text":"array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}