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'