BUG #3305: multiple Operator classes

Поиск
Список
Период
Сортировка
От Belykh Oleg
Тема BUG #3305: multiple Operator classes
Дата
Msg-id 200705250620.l4P6KMxv020962@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3305: multiple Operator classes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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);

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3301: explain crashes server on simple (?) query
Следующее
От: "ann"
Дата:
Сообщение: BUG #3307: Software error when accessed