Displaying 1 result from an estimated 1 matches for "starting_d".
Did you mean:
starting_r
2007 Oct 25
1
find - group - postgres
...s I am trying to
run the command in postgres and I am getting the same error...
controller code...
@client_slot_count = ClientSlotsDaily.find(:all,
:conditions => ["created_at > ? AND created_at < ? AND
facility_id = ? AND client_id IS NOT NULL",
starting_date, ending_date, @facility.id],
:group => ''client_id'')
error reported is...
PGError: ERROR: column "client_slots_dailies.id" must appear in the
GROUP BY clause or be used in an aggregate function
: SELECT * FROM client_slots_dailies WHERE (created_at > &...