PG::GroupingError: ERROR: column "events.id" must appear in the GROUP BY clause or be used in an aggregate function

Question

An event has a column popularity and many keywords. A keyword has a category and a name. I am trying to order events by their popularity, but then only return the most popular event from each keyword name with the category "taxonomy".

Here's my query:

Event
  .order(:popularity)
  .joins(:keywords)
  .where(keywords: {category: "taxonomy"})
  .group("keywords.name")

But I am getting below error:

PG::GroupingError: ERROR: column "events.id" must appear in the GROUP BY clause or be used in an aggregate function

Where am I going wrong?

Postgres version ? some are suggesting to use 9.1 – Sajan Oct 18 '16 at 19:26 — Sajan, Oct 18 '16 at 19:26

Andrey Deineko · Accepted Answer · 2018-11-05T06:59:17.190

10

Event
  .order(:popularity)
  .joins(:keywords)
  .group('events.id') # <======
  .where(keywords: { category: 'taxonomy' })
  .group('keywords.name')

edited Nov 05 '18 at 06:59

answered Oct 18 '16 at 19:29

Andrey Deineko

51,333
10
112
145

PG::GroupingError: ERROR: column "events.id" must appear in the GROUP BY clause or be used in an aggregate function

1 Answers1

Linked