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

From ced45
Subject Postgresql 8.4, XPath and name() function
Date
Msg-id 29147655.post@talk.nabble.com
Whole thread Raw
Responses Re: Postgresql 8.4, XPath and name() function  (Thom Brown <thombrown@gmail.com>)
Re: Postgresql 8.4, XPath and name() function  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Hi List,

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" ?

Thanks in advance,

Cedric
--
View this message in context:
http://old.nabble.com/Postgresql-8.4%2C-XPath-and-name%28%29-function-tp29147655p29147655.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Andras Fabian
Date:
Subject: Re: PG_DUMP very slow because of STDOUT ??
Next
From: Andras Fabian
Date:
Subject: Re: PG_DUMP very slow because of STDOUT ??