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
--
Sent via pgsql-general mailing list (
Karl Koster wrote:
> It looks like I have to abandon xml2 functions in PostgreSQL
> 8.4. The problem is I can't seem to find an incantation of
> xpath that will perform the same thing. I have tried the
> following snippet:
> select xpath('/trade/trade-info/id/text()', cast(xml as
> xml))[1] as i
It looks like I have to abandon xml2 functions in PostgreSQL 8.4. The
problem is I can't seem to find an incantation of xpath that will
perform the same thing. I have tried the following snippet:
select xpath('/trade/trade-info/id/text()', cast(xml as xml))[1] as id
from risk.trade_table
whi
