IsXML() function
The IsXML() function determines whether an input argument is a compiled Netezza Performance Server XML document (that is, whether the input argument is of type XML).
It is important to explicitly check whether the XML that
you produce by embedding SQLX
functions within your SQL is valid XML, because the underlying SQLX
engine does not do any error
checking or validation. If you are using schemas, you are also responsible
for returning well-formed
XML (meaning that it conforms to the structure that is specified by
the schema).
Syntax
The IsXML() function has the following
syntax:
bool = IsXML(XML input);
The input value, which must be varchar, specifies the XML
object to analyze.
Returns
The function returns t (true) if the input varchar value is a compiled Netezza Performance Server XML document. Otherwise, the function returns f (false).
Example
select IsXML(XMLParse('<tag1>12345</tag1>'));
ISXML
-------
t
(1 row)