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 | 
| Список | 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 по дате отправления: