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
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)))
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))) WHERE attribute_toggles <> 0;
represented by such a