ROR heroku PostGres issue
- by oelbrenner
getting error:
ActiveRecord::StatementInvalid (PGError: ERROR: argument of HAVING must be type boolean, not type timestamp without time zone
controller code snippet:
def inactive
@number_days = params[:days].to_i || 90
@clients = Client.find(:all,
:include = :appointments,
:conditions = ["clients.user_id = ? AND appointments.start_time <= ?", current_user.id, @number_days.days.ago],
:group = 'client_id',
:having = 'MAX(appointments.start_time)'
)
end
