operators and indices?

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема operators and indices?
Дата
Msg-id Pine.BSO.4.10.10105172051110.20890-100000@spider.pilosoft.com
обсуждение исходный текст
Ответы Re: operators and indices?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello,

I've noticed that all custom operators or inet type (such as <<, <<=, etc)  
cannot use an index, even though it is possible to define such an
operation on an index, for ex:
X << Y can be translated to "X >= network(Y) && X <= broadcast(Y)" (or so)

According to docs, postgres has hard-coded the ops which match index types
(such as btree for <,>,=, etc and rtree for @, etc). Is there a better way
than hardcoding support for inet types into index-selection code?

-alex



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

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: Plans for solving the VACUUM problem
Следующее
От: Mike Mascari
Дата:
Сообщение: RE: Plans for solving the VACUUM problem