Search Postgresql Archives

Re: XML Index again

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yup you are right .... however I am trying to run benchmarks with the two solutions.  

The xml solution will give us more flexibility in the future , just in case we do not have attribute/value lists :)


On Mon, Mar 8, 2010 at 1:33 PM, Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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:1034,4b94e081296926114815748!




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux