Hi guys: Having this strange problem using Rails on Postgres. I'm trying to count up the records that match a certain created_at date, but they don't seem to be grouping in order. Tip: this worked fine in MySQL, but I need to use Heroku, which is Postgres only....
Here is my query:
@graphdata = Capture.count(:group => "to_char(created_at,'YYYYMMDD000000')", :conditions => "created_at between '"+@rangestart+"' and '"+@rangeend+"' and ("+@searchterms+")", :select => "created_at")
But when I try to output this, the order is all wonky:
20100302000000:994< 20100222000000:2964< 20100227000000:4853< 20100301000000:7143< 20100226000000:5340< 20100223000000:3517< 20100221000000:196< 20100225000000:4485< 20100224000000:4068< 20100228000000:15335<
Any ideas? I tried adding :order to the query and it broke...
Thanks...Chris