Rails/Postgres: Column must appear in group by clause

Question

So Postgres is complaining about:

PGError: ERROR:  column "sessions.created_at" must appear in the GROUP BY clause or be used in an aggregate function

But the trouble is, "created_at" does appear in the group by clause:

SELECT     created_at, count(id) as visit_count FROM       "sessions"  WHERE     ("sessions"."site_id" IN (4, 3)) AND ("sessions"."created_at" >= '2011-10-20 00:00:00.000000') AND ("sessions"."created_at" <= '2011-10-27 23:59:59.999999') GROUP BY  date(created_at))

Does it have something to do with created_at being wrapped in date() perhaps?

Thanks in advance!

user330315 · Accepted Answer · 2011-10-27 15:17:45Z

4

No, it does not appear.

The GROUP BY contains date(created_at) whereas your SELECT list only contains created_at. If created_at is a timestamp, then these are two different things.

You either need to use GROUPY BY created_at or SELECT date(created_at) (probably the latter)

answered Oct 27, 2011 at 15:17

user330315

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

Collectives™ on Stack Overflow

Rails/Postgres: Column must appear in group by clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related