def in other
case other
when Arel::SelectManager
Arel::Nodes::In.new(self, other.ast)
when Range
if other.begin == -Float::INFINITY && other.end == Float::INFINITY
Nodes::NotIn.new self, []
elsif other.end == Float::INFINITY
Nodes::GreaterThanOrEqual.new(self, other.begin)
elsif other.begin == -Float::INFINITY && other.exclude_end?
Nodes::LessThan.new(self, other.end)
elsif other.begin == -Float::INFINITY
Nodes::LessThanOrEqual.new(self, other.end)
elsif other.exclude_end?
left = Nodes::GreaterThanOrEqual.new(self, other.begin)
right = Nodes::LessThan.new(self, other.end)
Nodes::And.new [left, right]
else
Nodes::Between.new(self, Nodes::And.new([other.begin, other.end]))
end
else
Nodes::In.new self, other
end
end