Added support for INTERSECT and EXCEPT

3 files changed, 20 insertions, 0 deletions

diff --git a/lib/arel/nodes/binary.rb b/lib/arel/nodes/binary.rb
index e72228f11c..bcd46db398 100644
--- a/lib/arel/nodes/binary.rb
+++ b/lib/arel/nodes/binary.rb
@@ -31,6 +31,8 @@ module Arel
       Or
       Union
       UnionAll
+      Intersect
+      Except
     }.each do |name|
       const_set name, Class.new(Binary)
     end
diff --git a/lib/arel/select_manager.rb b/lib/arel/select_manager.rb
index 4e1382224d..afc46a626e 100644
--- a/lib/arel/select_manager.rb
+++ b/lib/arel/select_manager.rb
@@ -145,6 +145,16 @@ module Arel
       node_class.new self.ast, other.ast
     end
 
+    def intersect other = nil
+      node_class = Nodes::Intersect
+      node_class.new self.ast, other.ast
+    end
+
+    def except other = nil
+      node_class = Nodes::Except
+      node_class.new self.ast, other.ast
+    end
+
     def with *subqueries
       if subqueries.first.is_a? Symbol
         node_class = Nodes.const_get("With#{subqueries.shift.to_s.capitalize}")
diff --git a/lib/arel/visitors/to_sql.rb b/lib/arel/visitors/to_sql.rb
index 7cb4213fbb..a395b7f765 100644
--- a/lib/arel/visitors/to_sql.rb
+++ b/lib/arel/visitors/to_sql.rb
@@ -166,6 +166,14 @@ key on UpdateManager using UpdateManager#key=
         "( #{visit o.left} UNION ALL #{visit o.right} )"
       end
 
+      def visit_Arel_Nodes_Intersect o
+        "( #{visit o.left} INTERSECT #{visit o.right} )"
+      end
+
+      def visit_Arel_Nodes_Except o
+        "( #{visit o.left} EXCEPT #{visit o.right} )"
+      end
+
       def visit_Arel_Nodes_Having o
         "HAVING #{visit o.expr}"
       end