minimum operators for b-tree, r-tree - Mailing list pgsql-general

From elein
Subject minimum operators for b-tree, r-tree
Date
Msg-id 20040629220309.P30062@cookie.varlena.com
Whole thread Raw
Responses Re: minimum operators for b-tree, r-tree  (Joe Conway <mail@joeconway.com>)
Re: minimum operators for b-tree, r-tree  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
When creating a new data type, what are
the operators absolutely necessary for that
type to particpate in a btree index?

I know you need a "compare" that says = < or >=
so does that mean that those three operators
are the ones required?

If you also know that answer for our implementation
of R-trees that would also be helpful.
I believe it is intersects and overlaps but
it would be nice to get confirmation.

Thanks,
elein
============================================================
elein@varlena.com        Varlena, LLC        www.varlena.com

          PostgreSQL Consulting, Support & Training

PostgreSQL General Bits   http://www.varlena.com/GeneralBits/
=============================================================
I have always depended on the [QA] of strangers.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql install: jdbc: No such file or directory.
Next
From: Tom Lane
Date:
Subject: Re: FULL JOIN and mergjoinable conditions...