Re: ltree and ordering - what index?

From: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: ltree and ordering - what index?
Date: 2005-09-19 05:23:54
Message-ID: 9e4684ce050918222319e61209@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/18/05, Jim C. Nasby <jnasby(at)pervasive(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2005-09-19 05:27:05 Re: BIG installations of PostgresQL?
Previous Message suresh ramasamy 2005-09-19 04:02:46 help me pls