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.