Re: [GENERAL] Postgresql 8.4, XPath and name() function

2010-07-13 Thread ced45
Thom Brown wrote: > > Have you tried: > > SELECT XPATH('fn:name(/*)', XMLPARSE(DOCUMENT 'value')); > > Thom > > Thanks for your help, but it gives the whole element and not only the markup name. Cedric -- View this message in context: http://old.nabble.com/Postgresql-8.4%2C-XPath-and-name

[GENERAL] Postgresql 8.4, XPath and name() function

2010-07-13 Thread ced45
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 'value')) I would like to get "unit", but I just get an empty array ({}). How can I get "unit" ? Thanks in advance, Cedric -- View