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