Re: Btree index extension question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Btree index extension question
Дата
Msg-id 22171.1016211989@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Btree index extension question  (Dmitry Tkach <dmitry@openratings.com>)
Список pgsql-sql
Dmitry Tkach <dmitry@openratings.com> writes:
> Does btree require a complete order defined?

Yes, absolutely.  I do not think that btree is a useful index type for
your problem.  Nor rtree (our rtree implementation can only do 2-D
AFAIK).

You might have better luck with GIST.  In particular contrib/intarray
would be worth looking at for inspiration.  (You could even use it
directly if you cared to change your data representation, I think.)
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: Btree index extension question
Следующее
От: Dmitry Tkach
Дата:
Сообщение: Re: Btree index extension question