Postgresql 8.4, XPath and name() function

From: ced45 <cedric(dot)duprez(at)ifn(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql 8.4, XPath and name() function
Date: 2010-07-13 08:03:23
Message-ID: 29147655.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andras Fabian 2010-07-13 08:05:26 Re: PG_DUMP very slow because of STDOUT ??
Previous Message Josip Rodin 2010-07-13 07:55:53 Re: simple functions, huge overhead, no cache