BUG #3305: multiple Operator classes

From: "Belykh Oleg" <oleg(at)efmc(dot)kz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3305: multiple Operator classes
Date: 2007-05-25 06:20:22
Message-ID: 200705250620.l4P6KMxv020962@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3305
Logged by: Belykh Oleg
Email address: oleg(at)efmc(dot)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);

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message ann 2007-05-25 13:15:44 BUG #3307: Software error when accessed
Previous Message Tom Lane 2007-05-24 18:59:43 Re: BUG #3301: explain crashes server on simple (?) query