Thank you! Since you brought up the subject, will this //[EMAIL PROTECTED] = "02"] be slower than /mydocument/body/chapter/contents/[EMAIL PROTECTED] >> = "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/[EMAIL PROTECTED] >> = "02"]|/mydocument/body/[EMAIL PROTECTED]"87"]') >> FROM xmltable >> WHERE id = 3 > > You could maybe use the xpath: '//[EMAIL PROTECTED] = "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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- ~~~~~~~~~~~~~~~~~~~~~~~ - S o f t E x p e r t - ~~~~~~~~~~~~~~~~~~~~~~~ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match