Re: [sqlalchemy] concerns over generating a bitwise comparison in postgres - (or "can columns be explicit in a text filter?"

2016-09-28 Thread Jonathan Vanasco
Ok. I'll put a note on the code and leave as is. The cast/bit/op is just too hard to read for maintenance. BUT it might be okay in one spot as a compiles function. I think i may do that! Thanks, Mike! -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] concerns over generating a bitwise comparison in postgres - (or "can columns be explicit in a text filter?"

2016-09-28 Thread Mike Bayer
On 09/27/2016 05:12 PM, Jonathan Vanasco wrote: Let's say that I have a table such as this: CREATE TABLE foo ( id SERIAL PRIMARY KEY, attribute_toggles INT DEFAULT NULL ); CREATE INDEX idx_attribute_toggles ON foo(CAST(attribute_toggles AS BIT(32)))