From 74caeaad157e79853b9c6804f561d3c70eea2346 Mon Sep 17 00:00:00 2001
From: Brian Cardarella <bcardarella@gmail.com>
Date: Sat, 22 Jan 2011 09:16:53 -0500
Subject: Added support for INTERSECT and EXCEPT

---
 lib/arel/nodes/binary.rb    |  2 ++
 lib/arel/select_manager.rb  | 10 ++++++++++
 lib/arel/visitors/to_sql.rb |  8 ++++++++
 3 files changed, 20 insertions(+)

(limited to 'lib/arel')

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
-- 
cgit v1.2.3