using index on comparison with bit-operation?

Поиск
Список
Период
Сортировка
От geek_1981@yahoo.de (Michael Groth)
Тема using index on comparison with bit-operation?
Дата
Msg-id e78bf033.0404070501.573bc209@posting.google.com
обсуждение исходный текст
Ответы Re: using index on comparison with bit-operation?
Re: using index on comparison with bit-operation?
Список pgsql-hackers
hi,

is it possible to use an index on the expression '(table_1.field &
table_2.field)::int > 0' ?

here's the whole query:

SELECT COUNT(*)
FROMusers AS users
JOINsearch_profile AS search_profile ON
(search_profile.bin_matching_field_0 &
users.bin_matching_field_0)::int > 0
WHEREusers.id = 190
best regards

michael


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