Search Postgresql Archives

Re: ltree and ordering - what index?

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

 



On 9/18/05, Jim C. Nasby <jnasby@xxxxxxxxxxxxx> wrote:
ltree is part of contrib, right?


yes.
 

You probably need to define a functional index of some kind. How are you
querying now? IIRC you'll be doing something like region IN (ltree)?

i didn't thought about functional indices, but this might be a solution. have to think about it for a while
searching through ltree's is done using specific operators (>@).

depesz

[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