select xpath ... - Mailing list pgsql-sql

From boris
Subject select xpath ...
Date
Msg-id j52me3$ehq$1@speranza.aioe.org
Whole thread Raw
Responses Re: select xpath ...
List pgsql-sql
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.





pgsql-sql by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: Passing function parameters to regexp_replace
Next
From: nicoletta maia
Date:
Subject: Re: Window function sort order help