ROR heroku PostGres issue

Question

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

changed
:having => 'MAX(appointments.start_time)'
to
:having => ['MAX(appointments.start_time) <= ?', @number_days.days.ago]
and now error is:
ActiveRecord::StatementInvalid (PGError: ERROR: column "clients.id" must appear in the GROUP BY clause or be used in an aggregate function

I suggest you brush up on SQL's WHERE, HAVING and GROUP BY clauses. w3schools.com/sql/sql_having.asp. This is not a Rails issue. — JRL
– JRL, Commented Apr 24, 2010 at 15:39
yeah, its definitely a postgres is stricter then sqlite thing, just trying to find a solution.... still learning — sysconfig
– sysconfig, Commented Apr 24, 2010 at 22:31

John Douthat · Accepted Answer · 2010-04-24 05:49:02Z

4

The :having clause requires a SQL snippet that evaluates to a boolean. MAX(appointments.start_time) evaluates to a timestamp

edited Apr 24, 2010 at 5:49

answered Apr 24, 2010 at 4:42

John Douthat

41.3k11 gold badges71 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tadas T · Accepted Answer · 2010-04-25 21:28:19Z

0

change :group => 'client_id' to :group => 'table_name.client_id'

answered Apr 25, 2010 at 21:28

Tadas T

2,65721 silver badges20 bronze badges

Collectives™ on Stack Overflow

ROR heroku PostGres issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related