Re: Btree index extension question - Mailing list pgsql-sql

From Tom Lane
Subject Re: Btree index extension question
Date
Msg-id 22171.1016211989@sss.pgh.pa.us
Whole thread Raw
In response to Btree index extension question  (Dmitry Tkach <dmitry@openratings.com>)
List 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 by date:

Previous
From: Dmitry Tkach
Date:
Subject: Btree index extension question
Next
From: Dmitry Tkach
Date:
Subject: Re: Btree index extension question