{"Entry":{"collection":"func","key":"xmlagg","name":"xmlagg","aliases":[],"metadata":{"changed_in":["8.4","17"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.2","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.3"},{"descriptions_changed":true,"doc_overhaul":false,"from":"8.3","group_changed":null,"signatures":{"added":["xmlagg ( expression ) → xml"],"removed":[]},"status":"changed","to":"8.4"},{"descriptions_changed":true,"doc_overhaul":false,"from":"8.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"9.0"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.1","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"9.2"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":false,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":["xmlagg ( xml ORDER BY input_sort_columns ) → xml"],"removed":[]},"status":"changed","to":"17"},{"descriptions_changed":true,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"19"}],"content_hash":"92ae2569b4ea21d447cd359aa5e136d6d0b345aaa8d43621e6355b41e761e5cc","first_version":"8.3","group":"xml","group_label":"Xml Functions","groups":["xml","aggregate"],"imported_at":"2026-09-27T17:57:28.790282+08:00","last_version":"20","name":"xmlagg","name_key":"xmlagg","position":15017,"present_in":["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":"xmlagg ( xml ) → xml","signature_count":2,"slug":"xmlagg","source_rev":"b7bd9cda","summary":"The function xmlagg is, unlike the other functions described here, an aggregate function.","summary_zh":""}},"Definition":{"Collection":"func","Key":"xmlagg","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"xmlagg","SourceRevision":"b7bd9cda","Facts":{"description":"The function xmlagg is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like xmlconcat does, except that concatenation occurs across rows rather than across expressions in a single row. See Section 9.21 for additional information about aggregate functions.","description_html":"The function \u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like \u003ccode class=\"function\"\u003exmlconcat\u003c/code\u003e does, except that concatenation occurs across rows rather than across expressions in a single row. See \u003ca href=\"/docs/18/functions-aggregate.html\" title=\"9.21. Aggregate Functions\"\u003eSection 9.21\u003c/a\u003e for additional information about aggregate functions.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-XML-XMLAGG","file":"functions-xml.html","slug":"18"},"group":"xml","group_label":"Xml Functions","lang":"en","layout":"table-new","pages":["functions-xml.html","functions-aggregate.html"],"prose_only":false,"signatures":[{"description":"The function xmlagg is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like xmlconcat does, except that concatenation occurs across rows rather than across expressions in a single row. See Section 9.21 for additional information about aggregate functions.","description_html":"The function \u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like \u003ccode class=\"function\"\u003exmlconcat\u003c/code\u003e does, except that concatenation occurs across rows rather than across expressions in a single row. See \u003ca href=\"/docs/18/functions-aggregate.html\" title=\"9.21. Aggregate Functions\"\u003eSection 9.21\u003c/a\u003e for additional information about aggregate functions.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e ( \u003ccode class=\"type\"\u003exml\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlagg ( xml ) → xml","zh_from":""},{"description":"Concatenates the non-null XML input values (see Section 9.15.1.8).","description_html":"Concatenates the non-null XML input values (see \u003ca href=\"/docs/18/functions-xml.html#FUNCTIONS-XML-XMLAGG\" title=\"9.15.1.8. xmlagg\"\u003eSection 9.15.1.8\u003c/a\u003e).","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e ( \u003ccode class=\"type\"\u003exml\u003c/code\u003e \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"literal\"\u003einput_sort_columns\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlagg ( xml ORDER BY input_sort_columns ) → xml","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-XML-XMLAGG","file":"functions-xml.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"xmlagg","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"xmlagg","Summary":"和这里描述的其他函数不同，函数xmlagg是一个聚合函数。它将聚合函数调用的输入值串接起来，非常像xmlconcat所做的事情，除了串接是跨行发生的而不是在单一行的多个表达式上发生。聚合函数的更多信息请见第 9.21 节。","BodyHTML":"和这里描述的其他函数不同，函数\u003ccode\u003exmlagg\u003c/code\u003e是一个聚合函数。它将聚合函数调用的输入值串接起来，非常像\u003ccode\u003exmlconcat\u003c/code\u003e所做的事情，除了串接是跨行发生的而不是在单一行的多个表达式上发生。聚合函数的更多信息请见\u003ca href=\"/docs/18/functions-aggregate.html\" rel=\"nofollow\"\u003e第 9.21 节\u003c/a\u003e。\u003cpre\u003exmlagg ( xml ) → xml\u003c/pre\u003e和这里描述的其他函数不同，函数\u003ccode\u003exmlagg\u003c/code\u003e是一个聚合函数。它将聚合函数调用的输入值串接起来，非常像\u003ccode\u003exmlconcat\u003c/code\u003e所做的事情，除了串接是跨行发生的而不是在单一行的多个表达式上发生。聚合函数的更多信息请见\u003ca href=\"/docs/18/functions-aggregate.html\" rel=\"nofollow\"\u003e第 9.21 节\u003c/a\u003e。\u003cpre\u003exmlagg ( xml ORDER BY input_sort_columns ) → xml\u003c/pre\u003e连接非空的 XML 输入值（参见\u003ca href=\"/docs/18/functions-xml.html#FUNCTIONS-XML-XMLAGG\" rel=\"nofollow\"\u003e第 9.15.1.8 节\u003c/a\u003e）。","SourceRevision":"ca936764","ContentHash":"5d0574d9c03fce3bfd89f16a31f840391bf3556bc35376d92f67930b8ad83d57","Payload":{"description_zh":"和这里描述的其他函数不同，函数xmlagg是一个聚合函数。它将聚合函数调用的输入值串接起来，非常像xmlconcat所做的事情，除了串接是跨行发生的而不是在单一行的多个表达式上发生。聚合函数的更多信息请见第 9.21 节。","description_zh_html":"和这里描述的其他函数不同，函数\u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e是一个聚合函数。它将聚合函数调用的输入值串接起来，非常像\u003ccode class=\"function\"\u003exmlconcat\u003c/code\u003e所做的事情，除了串接是跨行发生的而不是在单一行的多个表达式上发生。聚合函数的更多信息请见\u003ca href=\"/docs/18/functions-aggregate.html\" title=\"9.21. 聚合函数\"\u003e第 9.21 节\u003c/a\u003e。","signatures":[{"description_zh":"和这里描述的其他函数不同，函数xmlagg是一个聚合函数。它将聚合函数调用的输入值串接起来，非常像xmlconcat所做的事情，除了串接是跨行发生的而不是在单一行的多个表达式上发生。聚合函数的更多信息请见第 9.21 节。","description_zh_html":"和这里描述的其他函数不同，函数\u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e是一个聚合函数。它将聚合函数调用的输入值串接起来，非常像\u003ccode class=\"function\"\u003exmlconcat\u003c/code\u003e所做的事情，除了串接是跨行发生的而不是在单一行的多个表达式上发生。聚合函数的更多信息请见\u003ca href=\"/docs/18/functions-aggregate.html\" title=\"9.21. 聚合函数\"\u003e第 9.21 节\u003c/a\u003e。","returns":"xml","text":"xmlagg ( xml ) → xml","zh_from":"doc"},{"description_zh":"连接非空的 XML 输入值（参见第 9.15.1.8 节）。","description_zh_html":"连接非空的 XML 输入值（参见\u003ca href=\"/docs/18/functions-xml.html#FUNCTIONS-XML-XMLAGG\" title=\"9.15.1.8. xmlagg\"\u003e第 9.15.1.8 节\u003c/a\u003e）。","returns":"xml","text":"xmlagg ( xml ORDER BY input_sort_columns ) → xml","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","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":"17185d25c98944d88327ead2f6e1be8e5096f10f93c201e3df37a6d954fc322a","Text":"xmlagg ( xml ) → xml","Returns":"xml","Payload":{"description":"The function xmlagg is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like xmlconcat does, except that concatenation occurs across rows rather than across expressions in a single row. See Section 9.21 for additional information about aggregate functions.","description_html":"The function \u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like \u003ccode class=\"function\"\u003exmlconcat\u003c/code\u003e does, except that concatenation occurs across rows rather than across expressions in a single row. See \u003ca href=\"/docs/18/functions-aggregate.html\" title=\"9.21. Aggregate Functions\"\u003eSection 9.21\u003c/a\u003e for additional information about aggregate functions.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e ( \u003ccode class=\"type\"\u003exml\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlagg ( xml ) → xml","zh_from":""}},{"Version":"18","Ordinal":1,"Hash":"980847d1a1c1b348146c08675cb18ad263035da7a7e94981c3308101c3a1bdec","Text":"xmlagg ( xml ORDER BY input_sort_columns ) → xml","Returns":"xml","Payload":{"description":"Concatenates the non-null XML input values (see Section 9.15.1.8).","description_html":"Concatenates the non-null XML input values (see \u003ca href=\"/docs/18/functions-xml.html#FUNCTIONS-XML-XMLAGG\" title=\"9.15.1.8. xmlagg\"\u003eSection 9.15.1.8\u003c/a\u003e).","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003exmlagg\u003c/code\u003e ( \u003ccode class=\"type\"\u003exml\u003c/code\u003e \u003ccode class=\"literal\"\u003eORDER BY\u003c/code\u003e \u003ccode class=\"literal\"\u003einput_sort_columns\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlagg ( xml ORDER BY input_sort_columns ) → xml","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}