Search Postgresql Archives

Re: XPath question - big trouble

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you!

Since you brought up the subject, will this
 //paragraph[@objid = "02"]
be slower than
/mydocument/body/chapter/contents/paragraph[@objid
>> = "02"] 
when handling a big document? 
I mean from the query time point of view ...


Csaba Nagy wrote:

> Marian,
> 
>> 1.
>> SELECT
>>         xpath_nodeset(xml_data,
>>         '/mydocument/body/chapter/contents/paragraph[@objid
>> = "02"]|/mydocument/body/paragraph[@objid="87"]')
>> FROM xmltable
>> WHERE id = 3
> 
> You could maybe use the xpath: '//paragraph[@objid = "02"]' if you want
> all paragraphs at all document levels.
> 
> A nice xslt reference is:
> file:///home/cnagy/offline/XSLTreference/Output/index.html
> 
> There you can also exercise your xpath skills...
> 
> Cheers,
> Csaba.
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
>        message can get through to the mailing list cleanly

-- 
~~~~~~~~~~~~~~~~~~~~~~~
- S o f t E x p e r t -
~~~~~~~~~~~~~~~~~~~~~~~



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux