Re: XPath question - big trouble

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 -
~~~~~~~~~~~~~~~~~~~~~~~

In response to

Responses

Browse pgsql-general by date

  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