Postgresql xpath Searching for attribute and element combination

Question

I was able to use Postgresql(9.4.x) xpath searching to match against an xml attribute or element. Is it possible to search the combination of both attribute and element value?

<name>
  <firstname>test</firstname>
  <lastname>user</lastname>
  <role num="10">admin</role>
  <role num="8">readonly</role>
</name>

I was trying to match admin role with number 10 in the above sample xml and below query does return TRUE for 8-admin combination as well.

select xpath('//role/@num="8" and //role/text()="admin"', '<above xml>');

Please suggest if there is any better way to matching exact index combination.

Thanks.

kjhughes · Accepted Answer · 2016-04-26 15:53:59Z

6

I was trying to match admin role with number 10

Try:

'//role[@num="10" and text()="admin"]'

Or if the name element for the admin is requested:

'//name[role[@num="10" and text()="admin"]]'

edited Apr 26, 2016 at 15:53

kjhughes

113k31 gold badges198 silver badges276 bronze badges

answered Apr 26, 2016 at 15:38

hr_117

9,6271 gold badge20 silver badges23 bronze badges

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

1 Comment

Prasad Over a year ago

That worked. Thank much for your help.I need to tweak my query little bit as I was using this in where clause and my previous query returned true/false where as this query returned value.

Collectives™ on Stack Overflow

Postgresql xpath Searching for attribute and element combination

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related