How to use XPath function name() on PostgreSQL

Question

If I use the following query, it shows ERROR: invalid XPath expression

The query is SELECT xpath('/foo/*/name()', '<foo><bar>test</bar></foo>')

I would get a list of node names.

Hanashi · Accepted Answer · 2014-12-04 11:47:26Z

3

I've found the answer: SELECT xpath('name()', unnest(xpath('/foo/*', '<foo><bar>test</bar><zar>test1</zar></foo>')))

answered Dec 4, 2014 at 11:47

Hanashi

6202 gold badges6 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1