Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group