| 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: | Whole Thread | Raw Message | 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 |