Boris, Can you send me your final solution? I am trying to do something similar and I think I am stuck at the namespace.
Thanks On Mon, Sep 19, 2011 at 11:49 AM, boris <boris@localhost.localdomain> wrote: > On 09/19/2011 10:49 AM, Rob Sargent wrote: >> >> Having a name space in the doc requires it's usage in the query. > > yeah, I got it... I was using wrong one... > thanks. > > >> >> >> On 09/17/2011 11:48 AM, boris wrote: >>> >>> hi all, >>> I've inserted xml file : >>> >>> <?xml version="1.0"?> >>> <document xmlns:s1="urn:myorg/s1" xmlns="urn:myorg" >>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> >>> <id num="111-222-333-4444"/> >>> <title>zzzzzz</title> >>> ...................... >>> >>> >>> to a table: >>> >>> CREATE TABLE "temp".tempxml >>> ( >>> record xml >>> ) >>> >>> I can get it using: >>> select * from temp.tempxml >>> >>> >>> but, I can't get any values using xpath. ex: >>> >>> >>> select (xpath('/document/title/text()', record ))[1] from temp.tempxml >>> >>> >>> am I doing it right? >>> >>> thanks. >>> >>> >>> >>> >> > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
