Tim Kane wrote
> clone=# create temp table xml_test (document xml);
> CREATE TABLE
If you know you need to use xpath on this content then you should do one of
the following:
SELECT CASE WHEN document IS DOCUMENT THEN xpath(...) ELSE
default_value_for_missing_data END;
CREATE TABLE xml_test (
doc
On 3/14/14, 11:12 AM, Tim Kane wrote:
> clone=# select xml_is_well_formed(' ');
> xml_is_well_formed
>
> t
> (1 row)
>
>
> clone=# select xpath_exists (‘//test', ' ');
> ERROR: could not parse XML document
> DETAIL: line 1: Start tag expected, '<' not found
There are sev
HI all,
I’ve had an interesting problem trying to perform an UPDATE based on the
results of processing an xpath against a field of type xml.
Specifically, my query would fail with:
> ERROR: could not parse XML document
> DETAIL: line 1: Start tag expected, '<' not found
I thought this strange
