XPath PostgreSQL 8.4
От | Karl Koster |
---|---|
Тема | XPath PostgreSQL 8.4 |
Дата | |
Msg-id | 4AD96635.4090805@optonline.net обсуждение исходный текст |
Список | pgsql-general |
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 which, from the documentation should give me the first (and only in this case) xml node text value for the XPath expression. Instead I get the following error message from the SQL parser: ERROR: syntax error at or near "[" LINE 1: ...h('/trade/trade-info/id/text()', cast(xml as xml))[1] as id ... ^ ********** Error ********** ERROR: syntax error at or near "[" SQL state: 42601 Character: 62 When I run the select statement without an array index, it correctly returns a single column of arrays of length one (expected) for the XPath node text value. Can anyone shine a light on what I am doing wrong? The build of the 8.4 database I am using is 8.4.1.9250. Thanks, Karl
В списке pgsql-general по дате отправления: