Issue with Result Counting in PostgreSQL about arel HOT 3 CLOSED

I just ran into this problem while trying to work around the issue of calling count on a relations with group causing the return value to be an ordered hash instead of an integer. Instead of grouping to remove duplicates, I tried using the slower "SELECT DISTINCT" method, but this was overridden by calling .count() on the relation.

from arel.

It looks like you can pass :distinct to the count option to ensure the count is distinct. It doesn't get applied automagically, but it should let you count distinct on user_id.

from arel.

Per #523, Arel development is moving to rails/rails.

If this issue is still relevant, please consider reopening it over there. (Note that the Rails repository does not accept feature request issues, and requires reproduction steps that rely on Active Record's documented API.)

from arel.