| From: | boris <boris(at)localhost(dot)localdomain> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: select xpath ... |
| Date: | 2011-09-19 15:49:03 |
| Message-ID: | j57o6v$67k$2@speranza.aioe.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
>>
>>
>>
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dianna Harter | 2011-09-19 21:31:57 | Re: Window function sort order help |
| Previous Message | Rob Sargent | 2011-09-19 14:49:20 | Re: select xpath ... |