{"Entry":{"collection":"func","key":"xmlexists","name":"XMLEXISTS","aliases":[],"metadata":{"changed_in":["12"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.1"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"10"},{"descriptions_changed":false,"doc_overhaul":false,"from":"11","group_changed":null,"signatures":{"added":["XMLEXISTS(text PASSING [BY { REF | VALUE }] xml [BY { REF | VALUE }])"],"removed":["XMLEXISTS(text PASSING [BY REF] xml [BY REF])"]},"status":"changed","to":"12"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"747981932c30f4c037be710034b936e63e7a7044247f58f6cd881b2d9d8568ef","derived_content_hash":"e8ee2f49f974dc450902007fc2f9a0feff2e20fa09be7b5e0afb1699fdab292d","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:bd7bb004a0066b034395bb69f08760fafa054fb9d2f8c5246d41bf916d72116f","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"9.1","group":"xml","group_label":"Xml Functions","groups":["xml"],"imported_at":"2026-09-14T21:49:48.770512+08:00","last_version":"20","name":"XMLEXISTS","name_key":"xmlexists","position":15021,"present_in":["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":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"d68fdf88cb0491851afff6d15aae0e9fd792d224aa8fadcbbbbe8639c9f5550b","repair":"wiki-repair-20261023"},"signature":"XMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean","signature_count":1,"slug":"xmlexists","source_rev":"wiki-repair-20261023:bd7bb004a0066b034395bb69f08760fafa054fb9d2f8c5246d41bf916d72116f","summary":"The function xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item.","summary_zh":""}},"Definition":{"Collection":"func","Key":"xmlexists","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"xmlexists","SourceRevision":"wiki-repair-20261023:bd7bb004a0066b034395bb69f08760fafa054fb9d2f8c5246d41bf916d72116f","Facts":{"description":"The function xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_html":"The function \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_zh":"函数 xmlexists 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","doc":{"anchor":"XML-EXISTS","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 xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_html":"The function \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_zh":"函数 xmlexists 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","examples":[],"html":"\u003ccode class=\"function\"\u003eXMLEXISTS\u003c/code\u003e ( \u003ccode class=\"type\"\u003etext\u003c/code\u003e \u003ccode class=\"literal\"\u003ePASSING\u003c/code\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eBY\u003c/code\u003e {\u003ccode class=\"literal\"\u003eREF\u003c/code\u003e|\u003ccode class=\"literal\"\u003eVALUE\u003c/code\u003e}\u003c/span\u003e] \u003ccode class=\"type\"\u003exml\u003c/code\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eBY\u003c/code\u003e {\u003ccode class=\"literal\"\u003eREF\u003c/code\u003e|\u003ccode class=\"literal\"\u003eVALUE\u003c/code\u003e}\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"XMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean","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":"XML-EXISTS","file":"functions-xml.html","sha256":"01aeb9b85a44b934664d02e73f09eba80ac8da243706dd1ea2b4943d6cf43a31","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"xmlexists","SourceDatabase":"center","Version":"18","Locale":"en","Title":"XMLEXISTS","Summary":"The function xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","BodyHTML":"The function \u003ccode\u003exmlexists\u003c/code\u003e evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","SourceRevision":"wiki-repair-20261023:bd7bb004a0066b034395bb69f08760fafa054fb9d2f8c5246d41bf916d72116f","ContentHash":"f1ae8cca76c0e9c4d2ebe1d7bc5ea281a91ab04e1b07bd84f18bdbaab787a0b7","Payload":{"description":"The function xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_html":"The function \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","signatures":[{"description":"The function xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_html":"The function \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_zh":"函数 xmlexists 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","examples":[],"html":"\u003ccode class=\"function\"\u003eXMLEXISTS\u003c/code\u003e ( \u003ccode class=\"type\"\u003etext\u003c/code\u003e \u003ccode class=\"literal\"\u003ePASSING\u003c/code\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eBY\u003c/code\u003e {\u003ccode class=\"literal\"\u003eREF\u003c/code\u003e|\u003ccode class=\"literal\"\u003eVALUE\u003c/code\u003e}\u003c/span\u003e] \u003ccode class=\"type\"\u003exml\u003c/code\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eBY\u003c/code\u003e {\u003ccode class=\"literal\"\u003eREF\u003c/code\u003e|\u003ccode class=\"literal\"\u003eVALUE\u003c/code\u003e}\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"XMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"0d3a9f5ab61fbf945823961fb7f6eded22283ccbe9ab931e96e93b3ddaae232e","Text":"XMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean","Returns":"boolean","Payload":{"description":"The function xmlexists evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_html":"The function \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e evaluates an XPath 1.0 expression (the first argument), with the passed XML value as its context item. The function returns false if the result of that evaluation yields an empty node-set, true if it yields any other value. The function returns null if any argument is null. A nonnull value passed as the context item must be an XML document, not a content fragment or any non-XML value.","description_zh":"函数 xmlexists 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","description_zh_html":"函数 \u003ccode class=\"function\"\u003exmlexists\u003c/code\u003e 对一个 XPath 1.0 表达式（第一个参数）求值，以传递的 XML 值作为其上下文项。如果求值结果产生一个空节点集，该函数返回 false，如果产生任何其他值，则返回 true。如果任何参数为空，则函数返回 null。作为上下文项传递的非空值必须是一个 XML 文档，而不是内容片段或任何非 XML 值。","examples":[],"html":"\u003ccode class=\"function\"\u003eXMLEXISTS\u003c/code\u003e ( \u003ccode class=\"type\"\u003etext\u003c/code\u003e \u003ccode class=\"literal\"\u003ePASSING\u003c/code\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eBY\u003c/code\u003e {\u003ccode class=\"literal\"\u003eREF\u003c/code\u003e|\u003ccode class=\"literal\"\u003eVALUE\u003c/code\u003e}\u003c/span\u003e] \u003ccode class=\"type\"\u003exml\u003c/code\u003e [\u003cspan class=\"optional\"\u003e\u003ccode class=\"literal\"\u003eBY\u003c/code\u003e {\u003ccode class=\"literal\"\u003eREF\u003c/code\u003e|\u003ccode class=\"literal\"\u003eVALUE\u003c/code\u003e}\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"XMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}