The following bug has been logged online:
Bug reference: 3305
Logged by: Belykh Oleg
Email address: oleg@efmc.kz
PostgreSQL version: 8.2
Operating system: MAC OS X
Description: multiple Operator classes
Details:
Index scan use only default operator class anyway, but there is 2 defined
operator classes.
1. This is partional value search (if values equal from begin)
CREATE OPERATOR CLASS treetype_pops DEFAULT
FOR TYPE treetype USING btree AS
OPERATOR 1 <,
OPERATOR 2 <=,
OPERATOR 3 @,
OPERATOR 4 >=,
OPERATOR 5 >,
FUNCTION 1 treetype_pcmp(treetype, treetype);
2. This is complete value search (values must be strictly equal)
CREATE OPERATOR CLASS treetype_ops
FOR TYPE treetype USING btree AS
OPERATOR 1 <,
OPERATOR 2 <=,
OPERATOR 3 =,
OPERATOR 4 >=,
OPERATOR 5 >,
FUNCTION 1 treetype_cmp(treetype, treetype);