bitwise comparison

[dwhalen]

Hey,

I am trying to convert my web application from Postgresql to oracle....want to give the clients an option. Anyway, amoung the many differences in sql, I am wondering if there is a way to do bitwise comparision in oracle. This is the query I use in postgresqlS:

SELECT actor_id 
FROM actor_preferences, user_bitmasks 
WHERE user_bitmasks.name like 'Entry' AND atp_user_mask ~ user_bitmasks.bitmask

Thanks for the help.

Hope I was clear

Later

 

[ddrillich]

thread759-749992 might help.

 

[SirCharles]

bitand(field, bitmask)=0 false
bitand(field, bitmask)!=0 true

 

[dwhalen]

Thanks for the replies....they saved my butt.
Works great


Later