[HACKERS] using index on comparison with bit-operation?

[Michael Groth]

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend