AFAIK, contrib/xml2 doesn't support namespaces for XPath expressions at all. Wait for PostgreSQL 8.3 :-)
On 7/9/07, CG <[EMAIL PROTECTED]> wrote:
select xpath_string($xml$<?xml version="1.0" ?> <f:foo xmlns:f="foo"> <f:bar>baz</f:bar> </f:foo> $xml$ ,'//f:bar/text()'); This does not give me back "baz" as I was expecting it to... It seems like xpath is ignoring the namespace directives in the source XML document. ____________________________________________________________________________________ TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV. http://tv.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
-- Best regards, Nikolay ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
