PG::InvalidColumnReference: ERROR: for SELECT DISTINCT in Ruby on Rails app

Question

I have a query that looks like this:

 Person.where.not(first_name: nil).where.not("lower(first_name)  = ?", 'mike').order('RANDOM()').limit(6).pluck("distinct(lower(first_name))")

It returns me the following error when I try to run it:

ActiveRecord::StatementInvalid: PG::InvalidColumnReference: ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...AND (NOT (lower(first_name)  = 'mike'))  ORDER BY RANDOM() L...

How can I solve this problem?

try Person.where.not(first_name: nil).where.not("lower(first_name) = ?", 'mike').order('RANDOM()').limit(6).pluck("lower(first_name)").uniq or Person.where('first_name IS NOT NULL and lower(first_name) != ?', 'mike').order('RANDOM()').limit(6).pluck("lower(first_name)").uniq — bunty
– bunty, Commented Jun 1, 2015 at 6:38

Vrushali Pawar · Accepted Answer · 2015-06-01 07:00:23Z

1

Person.where.not(first_name: nil).where.not("lower(first_name)  = ?", 'mike').order('RANDOM()').limit(6).select("lower(first_name)").uniq

Since pluck will fire extra query so instead of pluck you should use select

answered Jun 1, 2015 at 7:00

Vrushali Pawar

3,8131 gold badge16 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

PG::InvalidColumnReference: ERROR: for SELECT DISTINCT in Ruby on Rails app

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