| 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: | Whole Thread | Raw Message | 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 |