| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Chris Roffler <croffler(at)earthlink(dot)net> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: XML Index again |
| Date: | 2010-03-08 11:33:19 |
| Message-ID: | AB7E6346-5A01-4BB8-91A0-8BCA8C6D45B6@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8 Mar 2010, at 11:39, Chris Roffler wrote:
> Alban
>
> Thanks for your help, your suggestion worked.
>
> I need another xpath expression to find any Attribute with Name ="xxxx" under the Attributes node. (not just if it is in a specific position)
> see query below.
> How do I create an index for this xpath expression ?
Come to think of it... You seem to be storing an attribute/value list in the database in XML. Is there any reason not to store the attributes and their values as a normal table? Your approach seems a bit over-complicated and you seem to have some trouble getting your own mind around it.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4b94e083296929244758856!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A B | 2010-03-08 12:12:32 | How to find out if row was modified by EXECUTE UPDATE ... |
| Previous Message | Alban Hertroys | 2010-03-08 11:27:42 | Re: XML Index again |