Re: Postgresql 8.4, XPath and name() function - Mailing list pgsql-general

From Tim Landscheidt
Subject Re: Postgresql 8.4, XPath and name() function
Date
Msg-id m3zkxvgy88.fsf@passepartout.tim-landscheidt.de
Whole thread Raw
In response to Postgresql 8.4, XPath and name() function  (ced45 <cedric.duprez@ifn.fr>)
Responses Re: Postgresql 8.4, XPath and name() function  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
ced45 <cedric.duprez@ifn.fr> wrote:

> I have trouble using XPath name() function in a XML field.
> For example, when I execute the following query :

> SELECT XPATH('name(/*)', XMLPARSE(DOCUMENT '<unit>value</unit>'))

> I would like to get "unit", but I just get an empty array ({}).
> How can I get "unit" ?

AFAIK, this is not related to PostgreSQL, but inherent to
XPath in that it returns elements from the document that
fulfill the XPath expression *unchanged*.

  So you will probably have to tackle your problem from an-
other angle.

Tim

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Why can't I see the definition of my relations
Next
From: Bruce Momjian
Date:
Subject: Re: Testing 9.0beta3 and pg_upgrade