Having a name space in the doc requires it's usage in the query.
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.
>
>
>
>