BUG #3305: multiple Operator classes

Started by Belykh Olegalmost 19 years ago2 messagesbugs
Jump to latest
#1Belykh Oleg
oleg@efmc.kz

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Belykh Oleg (#1)
Re: BUG #3305: multiple Operator classes

"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