Re: XML Index again

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: XML Index again
Дата
Msg-id AB7E6346-5A01-4BB8-91A0-8BCA8C6D45B6@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на Re: XML Index again  (Chris Roffler <croffler@earthlink.net>)
Ответы Re: XML Index again  (Chris Roffler <croffler@earthlink.net>)
Список 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
isin 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
tostore the attributes and their values as a normal table? Your approach seems a bit over-complicated and you seem to
havesome 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!



В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: XML Index again
Следующее
От: A B
Дата:
Сообщение: How to find out if row was modified by EXECUTE UPDATE ...