{"Entry":{"collection":"func","key":"xmlroot","name":"xmlroot","aliases":[],"metadata":{"changed_in":["8.4"],"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":["xmlroot(xml, version text | no value [, standalone yes|no|no value])"],"removed":["xmlroot(xml, version text|no value [, standalone yes|no|no value])"]},"status":"changed","to":"8.4"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"5f3642e7d0bb9656e55923192eeaa6aac10d20181b88612b8b1da6b153c6ae18","derived_content_hash":"88de09fafa41f8d96d364e937fb98ae79a3318dfb0f5796ffdea6cc26942b08c","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:5aac20c8e049064e3ee8a43143c641b1d30cf9ad159b320b6db7339a84bf330a","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"8.3","group":"xml","group_label":"Xml Functions","groups":["xml"],"imported_at":"2026-09-27T17:57:28.807717+08:00","last_version":"20","name":"xmlroot","name_key":"xmlroot","position":15024,"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"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"bd9bf1b03237a4e0ec2d45b8668a548c8e5854b900914e3f9ee846c21165c6a5","repair":"wiki-repair-20261023"},"signature":"xmlroot ( xml, VERSION {text|NO VALUE} [, STANDALONE {YES|NO|NO VALUE} ] ) → xml","signature_count":1,"slug":"xmlroot","source_rev":"wiki-repair-20261023:5aac20c8e049064e3ee8a43143c641b1d30cf9ad159b320b6db7339a84bf330a","summary":"The xmlroot expression alters the properties of the root node of an XML value.","summary_zh":""}},"Definition":{"Collection":"func","Key":"xmlroot","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"xmlroot","SourceRevision":"wiki-repair-20261023:5aac20c8e049064e3ee8a43143c641b1d30cf9ad159b320b6db7339a84bf330a","Facts":{"description":"The xmlroot expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_html":"The \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_zh":"表达式 xmlroot 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","description_zh_html":"表达式 \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","doc":{"anchor":"FUNCTIONS-PRODUCING-XML-XMLROOT","file":"functions-xml.html","sha256":"01aeb9b85a44b934664d02e73f09eba80ac8da243706dd1ea2b4943d6cf43a31","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-xml.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"01aeb9b85a44b934664d02e73f09eba80ac8da243706dd1ea2b4943d6cf43a31","version":"18.7"},{"file":"functions-xml.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7f81f95d894b56436ba5c9f248999c6f79a15eff2f8e02803e9578894005ba44","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"xml","group_label":"XML 函数","lang":"en","layout":"table-new","pages":["functions-xml.html"],"prose_only":false,"signatures":[{"description":"The xmlroot expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_html":"The \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_zh":"表达式 xmlroot 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","description_zh_html":"表达式 \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","examples":[],"html":"\u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e ( \u003ccode class=\"type\"\u003exml\u003c/code\u003e, \u003ccode class=\"literal\"\u003eVERSION\u003c/code\u003e {\u003ccode class=\"type\"\u003etext\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO VALUE\u003c/code\u003e} [\u003cspan class=\"optional\"\u003e, \u003ccode class=\"literal\"\u003eSTANDALONE\u003c/code\u003e {\u003ccode class=\"literal\"\u003eYES\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO VALUE\u003c/code\u003e} \u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlroot ( xml, VERSION {text|NO VALUE} [, STANDALONE {YES|NO|NO VALUE} ] ) → xml","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-xml.html","sha256":"fecb5d8486a96d59e4b5808eeaa769d216ab3be80602eb0c73702f28dd37388c"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-PRODUCING-XML-XMLROOT","file":"functions-xml.html","sha256":"01aeb9b85a44b934664d02e73f09eba80ac8da243706dd1ea2b4943d6cf43a31","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"xmlroot","SourceDatabase":"center","Version":"18","Locale":"en","Title":"xmlroot","Summary":"The xmlroot expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","BodyHTML":"The \u003ccode\u003exmlroot\u003c/code\u003e expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node\u0026#39;s version declaration; if a standalone setting is specified, it replaces the value in the root node\u0026#39;s standalone declaration.","SourceRevision":"wiki-repair-20261023:5aac20c8e049064e3ee8a43143c641b1d30cf9ad159b320b6db7339a84bf330a","ContentHash":"688abcc881f877b7fe26b23d7fe7853c3af603020c428cddd625c2db9a336757","Payload":{"description":"The xmlroot expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_html":"The \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","signatures":[{"description":"The xmlroot expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_html":"The \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_zh":"表达式 xmlroot 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","description_zh_html":"表达式 \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","examples":[],"html":"\u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e ( \u003ccode class=\"type\"\u003exml\u003c/code\u003e, \u003ccode class=\"literal\"\u003eVERSION\u003c/code\u003e {\u003ccode class=\"type\"\u003etext\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO VALUE\u003c/code\u003e} [\u003cspan class=\"optional\"\u003e, \u003ccode class=\"literal\"\u003eSTANDALONE\u003c/code\u003e {\u003ccode class=\"literal\"\u003eYES\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO VALUE\u003c/code\u003e} \u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlroot ( xml, VERSION {text|NO VALUE} [, STANDALONE {YES|NO|NO VALUE} ] ) → xml","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","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":"5abfbd0a8615a5e349d13a832bac49223316fb923546dac1aa8e1d6733d381a2","Text":"xmlroot ( xml, VERSION {text|NO VALUE} [, STANDALONE {YES|NO|NO VALUE} ] ) → xml","Returns":"xml","Payload":{"description":"The xmlroot expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_html":"The \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e expression alters the properties of the root node of an XML value. If a version is specified, it replaces the value in the root node's version declaration; if a standalone setting is specified, it replaces the value in the root node's standalone declaration.","description_zh":"表达式 xmlroot 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","description_zh_html":"表达式 \u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e 修改一个 XML 值的根节点的属性。如果指定了一个版本，它会替换根节点的版本声明中的值；如果指定了一个独立设置，它会替换根节点的独立声明中的值。","examples":[],"html":"\u003ccode class=\"function\"\u003exmlroot\u003c/code\u003e ( \u003ccode class=\"type\"\u003exml\u003c/code\u003e, \u003ccode class=\"literal\"\u003eVERSION\u003c/code\u003e {\u003ccode class=\"type\"\u003etext\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO VALUE\u003c/code\u003e} [\u003cspan class=\"optional\"\u003e, \u003ccode class=\"literal\"\u003eSTANDALONE\u003c/code\u003e {\u003ccode class=\"literal\"\u003eYES\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO\u003c/code\u003e|\u003ccode class=\"literal\"\u003eNO VALUE\u003c/code\u003e} \u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmlroot ( xml, VERSION {text|NO VALUE} [, STANDALONE {YES|NO|NO VALUE} ] ) → xml","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}