On Wed, 2011-01-19 at 08:15 +0100, Dennis Gearon wrote: > I was wondering if the are binary operation filters? Haven't seen any in the > book nor was able to find any using google. > > So if I had 0600(octal) in a permission field, and I wanted to return any > records that 'permission & 0400(octal)==TRUE', how would I filter that?
Don't you mean permission & 0400(octal) == 0400? Anyway, the functionality can be accomplished by extending your index a bit. You could split the permission into user, group and all parts, then use an expanded query. If the permission is 0755 it will be indexed as user_p:7 group_p:5 all_p:5 If you're searching for something with at least 0650 your query should be expanded to (user_p:7 OR user_p:6) AND (group_p:7 OR group_p:5) Alternatively you could represent the bits explicitly in the index: user_p:1 user_p:2 user_p:4 group_p:1 group_p:4 all_p:1 all_p:5 Then a search for 0650 would query with user_p:2 AND user_p:4 AND group_p:1 AND group_p:4 Finally you could represent all valid permission values, still split into parts with user_p:1 user_p:2 user_p:3 user_p:4 user_p:5 user_p:6 user_p:7 group_p:1 group_p:2 group_p:3 group_p:4 group_p:5 all_p:1 all_p:2 all_p:3 all_p:4 all_p:5 The query would be simply user_p:6 AND group_p:5
