From 66fc8add90445289f4926a914b0eea0c1989450f Mon Sep 17 00:00:00 2001
From: Aaron Patterson <aaron.patterson@gmail.com>
Date: Thu, 23 Sep 2010 13:37:03 -0700
Subject: writing code that makes me sad

---
 lib/arel/visitors/postgresql.rb | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'lib')

diff --git a/lib/arel/visitors/postgresql.rb b/lib/arel/visitors/postgresql.rb
index 5f0b23a11e..e8aa9b8cb3 100644
--- a/lib/arel/visitors/postgresql.rb
+++ b/lib/arel/visitors/postgresql.rb
@@ -12,7 +12,7 @@ module Arel
           sql = super(subquery)
           [
             "SELECT * FROM (#{sql}) AS id_list",
-            "ORDER BY #{o.orders.map { |x| visit x }.join(', ')}",
+            "ORDER BY #{aliased_orders(o.orders).join(', ')}",
             ("LIMIT #{o.limit}" if o.limit),
             (visit(o.offset) if o.offset),
           ].compact.join ' '
@@ -28,6 +28,11 @@ module Arel
           end
         end
       end
+
+      def aliased_orders orders
+        #orders = o.orders.map { |x| visit x }.join(', ').split(',')
+        (0...orders.size).map { |i| "id_list.alias_#{i}" }
+      end
     end
   end
 end
-- 
cgit v1.2.3