xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the xpath expression
Example:
> SELECT xpath_string('bcc','a/c') FROM src LIMIT 1;
'cc'
> SELECT xpath_string('b1b2','a/b') FROM src LIMIT 1;
'b1'
> SELECT xpath_string('b1b2','a/b[2]') FROM src LIMIT 1;
'b2'
> SELECT xpath_string('b1b2','a') FROM src LIMIT 1;
'b1b2'