xpath_string namespace issue...

From: CG <cgg007(at)yahoo(dot)com>
To: postgresql listserv <pgsql-general(at)postgresql(dot)org>
Subject: xpath_string namespace issue...
Date: 2007-06-29 15:12:53
Message-ID: 259352.24646.qm@web37906.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm not sure what I'm missing here... :)

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... How does one clue-in the xpath functions to the namespaces in the XML document?


____________________________________________________________________________________
Got a little couch potato?
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2007-06-29 15:15:54 Re: Standby servers and incrementally updated backups
Previous Message Jim Nasby 2007-06-29 15:12:10 Re: Need help with generic query