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