ced45 <cedric.duprez@xxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general