From: | Marian POPESCU <softexpert(at)libertysurf(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: XPath question - big trouble |
Date: | 2006-08-07 17:02:12 |
Message-ID: | eb7rma$3b5$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you!
Since you brought up the subject, will this
//paragraph[(at)objid = "02"]
be slower than
/mydocument/body/chapter/contents/paragraph[(at)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[(at)objid
>> = "02"]|/mydocument/body/paragraph[(at)objid="87"]')
>> FROM xmltable
>> WHERE id = 3
>
> You could maybe use the xpath: '//paragraph[(at)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
~~~~~~~~~~~~~~~~~~~~~~~
- S o f t E x p e r t -
~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2006-08-07 18:10:47 | psql: absolutes and toggles |
Previous Message | Jeff Davis | 2006-08-07 17:00:01 | Re: Practical maximums (was Re: PostgreSQL theoretical |