pgxml_xpath - solution.

hi,

john gray sent me this solution.

I had to work this out for someone a month or so back, and there is an
easy answer.

Use 'string(//@dft_entityid)' for the XPath and it will do this for you.
If you do this a lot, you might want to write a wrapper funtion to modify
your XPath string this way.

which means the following query works..

cfm=> SELECT loginid,pgxml_xpath(userdata,'string(//@dft_entityid)','','')
FROM urdr_users where id = 110;
loginid | pgxml_xpath
---------+-------------
110 | 74
(1 row)

Jeff.