Can't wait... Got to have it now. :( I patched xpath.c and created a function which takes a third parameter which are the known namespaces in a space delimited hash list ... I based the patch on some example code from the libxml website which works perfectly from the command line. However, in PostgreSQL, it only works 65% of the time. The other 35% of the time it returns an empty string. I have no idea how to debug that kind of problem. You make it sound like 8.3 will have full-featured xpath_* frunctions. Will it have full-featured xslt support as well? ----- Original Message ---- From: Nikolay Samokhvalov <samokhvalov@xxxxxxxxx> To: CG <cgg007@xxxxxxxxx> Cc: postgresql listserv <pgsql-general@xxxxxxxxxxxxxx> Sent: Monday, July 9, 2007 4:33:04 PM Subject: Re: [GENERAL] xpath_* namespace bug AFAIK, contrib/xml2 doesn't support namespaces for XPath expressions at all. Wait for PostgreSQL 8.3 :-) On 7/9/07, CG <cgg007@xxxxxxxxx> 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 ____________________________________________________________________________________ Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php
