Обсуждение: BUG #3305: multiple Operator classes

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);

"Belykh Oleg" <oleg@efmc.kz> writes:
> Index scan use only default operator class anyway, but there is 2 defined
> operator classes.

Perhaps you forgot to make an index using the nondefault opclass?

            regards, tom lane