I wrote:
> [...]> You have to put brackets around the function call:
> | select (xpath('/trade/trade-info/id/text()', cast(xml as xml)))[1] as id from risk.trade_table;
... or, after a look in the dictionary, whatever you call"(" and ")" :-).
Tim