Re: ltree and ordering - what index?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: ltree and ordering - what index?
Дата
Msg-id 9e4684ce050918222319e61209@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ltree and ordering - what index?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: ltree and ordering - what index?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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 по дате отправления:

Предыдущее
От: suresh ramasamy
Дата:
Сообщение: help me pls
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: BIG installations of PostgresQL?