Re: xpath_* namespace bug

From: "Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com>
To: CG <cgg007(at)yahoo(dot)com>
Cc: "postgresql listserv" <pgsql-general(at)postgresql(dot)org>
Subject: Re: xpath_* namespace bug
Date: 2007-07-09 20:33:04
Message-ID: e431ff4c0707091333w4a1ecac2n7c4db5f889b5af4b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

AFAIK, contrib/xml2 doesn't support namespaces for XPath expressions
at all. Wait for PostgreSQL 8.3 :-)

On 7/9/07, CG <cgg007(at)yahoo(dot)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 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-07-09 21:09:25 Re: Windows Vista not working
Previous Message Gregory Stark 2007-07-09 20:31:41 Re: Performance Question - Table Row Size