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(*)
FROM
users AS users
JOIN
search_profile AS search_profile ON
(search_profile.bin_matching_field_0 &
users.bin_matching_field_0)::int > 0
WHERE
users.id = 190
best regards
michael