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
============================================================
[EMAIL PROTECTED] 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
