{"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","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"],"signature":"XMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean","signature_count":1,"slug":"xmlexists","source_rev":"2026-09-14T13:14:25.684213+00:00@99e6866c","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":"2026-09-14T13:14:25.684213+00:00@99e6866c","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":"","description_zh_html":"","doc":{"anchor":"XML-EXISTS","file":"functions-xml.html","slug":"18"},"group":"xml","group_label":"Xml Functions","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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"XML-EXISTS","file":"functions-xml.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"xmlexists","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"XMLEXISTS","Summary":"函数xmlexists对一个 XPath 1.0 表达式（第一个参数）求值，以传递的XML值作为其上下文项。如果求值结果产生一个空节点集，该函数返回false，如果产生任何其他值，则返回true。如果任何参数为空，则函数返回null。作为上下文项传递的非空值必须是一个XML文档，而不是内容片段或任何非XML值。","BodyHTML":"函数\u003ccode\u003exmlexists\u003c/code\u003e对一个 XPath 1.0 表达式（第一个参数）求值，以传递的XML值作为其上下文项。如果求值结果产生一个空节点集，该函数返回false，如果产生任何其他值，则返回true。如果任何参数为空，则函数返回null。作为上下文项传递的非空值必须是一个XML文档，而不是内容片段或任何非XML值。\u003cpre\u003eXMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean\u003c/pre\u003e函数\u003ccode\u003exmlexists\u003c/code\u003e对一个 XPath 1.0 表达式（第一个参数）求值，以传递的XML值作为其上下文项。如果求值结果产生一个空节点集，该函数返回false，如果产生任何其他值，则返回true。如果任何参数为空，则函数返回null。作为上下文项传递的非空值必须是一个XML文档，而不是内容片段或任何非XML值。","SourceRevision":"ca936764","ContentHash":"db56ff45607d1a0450a558b6834a695ecabf80f0dd96e74893235511410c6b17","Payload":{"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值。","signatures":[{"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值。","returns":"boolean","text":"XMLEXISTS ( text PASSING [BY {REF|VALUE}] xml [BY {REF|VALUE}] ) → boolean","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}