Query:
Ticket.count(:group => 'date(created_at)', :having =>
['date_created_at >= ? and date_created_at <= ?', "2010-09-14",
"2010-10-13"])
Successful MySQL 5.1.41 output:
SELECT count(*) AS count_all, date(created_at) AS date_created_at FROM
`tickets` GROUP BY date(created_at) HAVING date_created_at >=
'2010-09-14' and date_created_at <= '2010-10-13'
PostgreSQL 8.4.5 error:
ActiveRecord::StatementInvalid (PGError: ERROR: column
"date_created_at" does not exist
LINE 1: ...FROM "tickets" GROUP BY date(created_at) HAVING
date_creat...
^
: SELECT count(*) AS count_all, date(created_at) AS date_created_at
FROM "tickets" GROUP BY date(created_at) HAVING date_created_at >=
'2010-09-14' and date_created_at <= '2010-10-13' )
Many thanks for the help!
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
