ruby - rails postgreSQL 无法使此查询正常工作(SUM、Group Order)

Question

当我在 SQLite 中尝试时，这个查询有效:

Transaction.where(:paid => true).select("created_at, SUM(amount) amount").group("DATE(created_at)").order('created_at')

但是当我用 postgreSQL 运行它时它不起作用。这是错误消息:

ActiveRecord::StatementInvalid: PGError: ERROR:  column "transactions.created_at" must appear in the GROUP BY clause or be used in an aggregate function : SELECT created_at, SUM(amount) as amount FROM "transactions" WHERE ("transactions"."paid" = 't') GROUP BY DATE(created_at) ORDER BY created_at

谁能帮帮我？

提前致谢

Answer 1

您必须在 select 子句中使用 DATE(created_at)，或者在 group by 子句中使用 created_at。