{"Entry":{"collection":"func","key":"xmltext","name":"xmltext","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"17"}],"content_hash":"b0661ca956481c2abf63263b9e446f99906729a43de47f7999f17cc44cf3d08a","derived_content_hash":"457047ed742b8f69b33fb7d7831270d0231f62cda4b91d490cb1f0ad1b940245","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:9da0d01af205d3fd7b25be9341f7de45b569994e1f48d151be573d2c16a6ec55","versions":{"17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"17","group":"xml","group_label":"Xml Functions","groups":["xml"],"imported_at":"2026-09-14T21:49:48.775035+08:00","last_version":"20","name":"xmltext","name_key":"xmltext","position":15026,"present_in":["17","18","19","20"],"repair_provenance":{"original_source_revision":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"78728e625d8d0920d221b62f6ea4d1b87f923712a921e40100ef0a2fed0da812","repair":"wiki-repair-20261023"},"signature":"xmltext ( text ) → xml","signature_count":1,"slug":"xmltext","source_rev":"wiki-repair-20261023:9da0d01af205d3fd7b25be9341f7de45b569994e1f48d151be573d2c16a6ec55","summary":"The function xmltext returns an XML value with a single text node containing the input argument as its content.","summary_zh":""}},"Definition":{"Collection":"func","Key":"xmltext","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"xmltext","SourceRevision":"wiki-repair-20261023:9da0d01af205d3fd7b25be9341f7de45b569994e1f48d151be573d2c16a6ec55","Facts":{"description":"The function xmltext returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u0026), left and right angle brackets (\u003c \u003e), and quotation marks (\"\") are escaped.","description_html":"The function \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e), left and right angle brackets (\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e), and quotation marks (\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e) are escaped.","description_zh":"函数 xmltext 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u0026）、左右尖括号（\u003c \u003e）以及引号（\"\"），都会被转义。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e）、左右尖括号（\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e）以及引号（\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e），都会被转义。","doc":{"anchor":"FUNCTIONS-PRODUCING-XML-XMLTEXT","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 function xmltext returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u0026), left and right angle brackets (\u003c \u003e), and quotation marks (\"\") are escaped.","description_html":"The function \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e), left and right angle brackets (\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e), and quotation marks (\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e) are escaped.","description_zh":"函数 xmltext 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u0026）、左右尖括号（\u003c \u003e）以及引号（\"\"），都会被转义。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e）、左右尖括号（\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e）以及引号（\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e），都会被转义。","examples":[],"html":"\u003ccode class=\"function\"\u003exmltext\u003c/code\u003e ( \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmltext ( text ) → 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-XMLTEXT","file":"functions-xml.html","sha256":"01aeb9b85a44b934664d02e73f09eba80ac8da243706dd1ea2b4943d6cf43a31","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"xmltext","SourceDatabase":"center","Version":"18","Locale":"en","Title":"xmltext","Summary":"The function xmltext returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u0026), left and right angle brackets (\u003c \u003e), and quotation marks (\"\") are escaped.","BodyHTML":"The function \u003ccode\u003exmltext\u003c/code\u003e returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u003ccode\u003e\u0026amp;\u003c/code\u003e), left and right angle brackets (\u003ccode\u003e\u0026lt; \u0026gt;\u003c/code\u003e), and quotation marks (\u003ccode\u003e\u0026#34;\u0026#34;\u003c/code\u003e) are escaped.","SourceRevision":"wiki-repair-20261023:9da0d01af205d3fd7b25be9341f7de45b569994e1f48d151be573d2c16a6ec55","ContentHash":"4200806d79237ee00ef03b2ac53c07cccb138c0ccb88e78cdcdb926df0b078ef","Payload":{"description":"The function xmltext returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u0026), left and right angle brackets (\u003c \u003e), and quotation marks (\"\") are escaped.","description_html":"The function \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e), left and right angle brackets (\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e), and quotation marks (\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e) are escaped.","signatures":[{"description":"The function xmltext returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u0026), left and right angle brackets (\u003c \u003e), and quotation marks (\"\") are escaped.","description_html":"The function \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e), left and right angle brackets (\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e), and quotation marks (\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e) are escaped.","description_zh":"函数 xmltext 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u0026）、左右尖括号（\u003c \u003e）以及引号（\"\"），都会被转义。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e）、左右尖括号（\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e）以及引号（\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e），都会被转义。","examples":[],"html":"\u003ccode class=\"function\"\u003exmltext\u003c/code\u003e ( \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmltext ( text ) → xml","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"67bab0c31a1c1f1ee742470492a03c89b5683e4f0000052c46ad7dcd4fd413b4","Text":"xmltext ( text ) → xml","Returns":"xml","Payload":{"description":"The function xmltext returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u0026), left and right angle brackets (\u003c \u003e), and quotation marks (\"\") are escaped.","description_html":"The function \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e returns an XML value with a single text node containing the input argument as its content. Predefined entities like ampersand (\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e), left and right angle brackets (\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e), and quotation marks (\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e) are escaped.","description_zh":"函数 xmltext 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u0026）、左右尖括号（\u003c \u003e）以及引号（\"\"），都会被转义。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmltext\u003c/code\u003e 返回一个只包含单个文本节点的 XML 值，该文本节点的内容就是输入参数。预定义实体，例如和号（\u003ccode class=\"literal\"\u003e\u0026amp;\u003c/code\u003e）、左右尖括号（\u003ccode class=\"literal\"\u003e\u0026lt; \u0026gt;\u003c/code\u003e）以及引号（\u003ccode class=\"literal\"\u003e\"\"\u003c/code\u003e），都会被转义。","examples":[],"html":"\u003ccode class=\"function\"\u003exmltext\u003c/code\u003e ( \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003exml\u003c/code\u003e","returns":"xml","text":"xmltext ( text ) → xml","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}
