How to remove SELECT expressions in query

[ealymbaev]

The gem adds the SELECT expressions like

"jobs"."id" AS t0_r0, "jobs"."job_description" AS t0_r1, .......

They cause error when using COUNT and GROUP BY functions in Postgres:

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

How can I remove them from the query?

P.S.

The rails code is:

states = Job.joins(listing: :location).select('count(locations.state) as count, locations.state').group('locations.state')

[ddarren]

I'm having a similar problem when grouping. I'd be happy with a hack for the time being to get this working.

[mintuhouse]

+1
I am trying to join a third table and select columns from it in vain. Does anyone know of a way to select required columns from third table?

[mintuhouse]

Use .unscoped to remove the default_scope