diff options
author | Aaron Patterson <aaron.patterson@gmail.com> | 2014-04-08 21:36:43 -0700 |
---|---|---|
committer | Aaron Patterson <aaron.patterson@gmail.com> | 2014-04-08 21:36:43 -0700 |
commit | bf791073972a179e6d79c8e2f89536734e315f54 (patch) | |
tree | e56c7a904337d4a07b3d2ff1502af7d67d7a7230 /lib/arel/visitors | |
parent | eba73dcbd505ce9b2ed28dc487e02046f1d9c257 (diff) | |
download | rails-bf791073972a179e6d79c8e2f89536734e315f54.tar.gz rails-bf791073972a179e6d79c8e2f89536734e315f54.tar.bz2 rails-bf791073972a179e6d79c8e2f89536734e315f54.zip |
fixing EXTRACT
Diffstat (limited to 'lib/arel/visitors')
-rw-r--r-- | lib/arel/visitors/to_sql.rb | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/lib/arel/visitors/to_sql.rb b/lib/arel/visitors/to_sql.rb index 7b0d6e2de1..9ec926a66e 100644 --- a/lib/arel/visitors/to_sql.rb +++ b/lib/arel/visitors/to_sql.rb @@ -448,8 +448,16 @@ module Arel end end - def visit_Arel_Nodes_Extract o - "EXTRACT(#{o.field.to_s.upcase} FROM #{visit o.expr})#{o.alias ? " AS #{visit o.alias}" : ''}" + def visit_Arel_Nodes_Extract o, collector + collector << "EXTRACT(#{o.field.to_s.upcase} FROM " + collector = visit o.expr, collector + collector << ")" + if o.alias + collector << " AS " + visit o.alias, collector + else + collector + end end def visit_Arel_Nodes_Count o, collector |