lib/groupdate/scopes.rb in groupdate-1.0.0 vs lib/groupdate/scopes.rb in groupdate-1.0.1

@@ -73,12 +73,12 @@
                   ["CONVERT_TZ(DATE_FORMAT(CONVERT_TZ(#{column}, '+00:00', ?), '#{format}'), ?, '+00:00')", time_zone, time_zone]
                 end
               when "PostgreSQL"
                 case field
                 when "day_of_week"
-                  ["EXTRACT(DOW from #{column}::timestamptz AT TIME ZONE ?)", time_zone]
+                  ["EXTRACT(DOW from #{column}::timestamptz AT TIME ZONE ?)::integer", time_zone]
                 when "hour_of_day"
-                  ["EXTRACT(HOUR from #{column}::timestamptz AT TIME ZONE ?)", time_zone]
+                  ["EXTRACT(HOUR from #{column}::timestamptz AT TIME ZONE ?)::integer", time_zone]
                 when "week" # start on Sunday, not PostgreSQL default Monday
                   ["(DATE_TRUNC('#{field}', (#{column}::timestamptz + INTERVAL '1 day') AT TIME ZONE ?) - INTERVAL '1 day') AT TIME ZONE ?", time_zone, time_zone]
                 else
                   ["DATE_TRUNC('#{field}', #{column}::timestamptz AT TIME ZONE ?) AT TIME ZONE ?", time_zone, time_zone]
                 end