Displaying 1 result from an estimated 1 matches for "and_id".
Did you mean:
ad_id
2011 Feb 17
1
Select distinict on not chainable with order method
Hi.
I would like to do code refactoring:
@beers = []
Beer.all.each do |beer|
unless @beers.find{|c| c.brand_id == beer.brand_id}
@beers << beer
end
break if @beers.size > 29
end
So I achieved this by writing scope (on PostgreSQL):
scope :with_unique_brand, select("DISTINCT ON (beers.brand_id)
beers.*")
Using this scope alone is working correct, however chaining...