AFAIK, contrib/xml2 doesn't support namespaces for XPath expressions
at all. Wait for PostgreSQL 8.3 :-)
On 7/9/07, CG <cgg007@yahoo.com> 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
inthe 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