Re: ltree and ordering - what index? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: ltree and ordering - what index?
Date
Msg-id 9e4684ce050918222319e61209@mail.gmail.com
Whole thread Raw
In response to Re: ltree and ordering - what index?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: ltree and ordering - what index?
List pgsql-general
On 9/18/05, Jim C. Nasby <jnasby@pervasive.com> 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

pgsql-general by date:

Previous
From: suresh ramasamy
Date:
Subject: help me pls
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: BIG installations of PostgresQL?