Rails - Nov 2008 - Named scope and order overriding

Hi everyone,
My question is: How do I override named_scope settings rather than merge
with them?

Say I have a model Vehicles
It has a named_scope called red_trucks that sets some filters and an
order by id.

Now lets say I want to find the unique values for an attribute.
So I might go

Vehicles.red_trucks.find(:all, "SELECT DISTINCT model_year")
This breaks in postgres with the following error
"for SELECT DISTINCT, ORDER BY expressions must appear in select list"

ok, so lets add the model_year
Vehicles.red_trucks.find(:all, "SELECT DISTINCT model_year",
:order=>"model_year")

This still gives me the same error because the ''order by id''
is still
there from the red_trucks name_scope. How do I override the order so it
because "model_year" instead of "model_year,id"?

Or is there a better way of doing this?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

aa aa wrote:
small typo
> This still gives me the same error because the ''order by
id'' is still
> there from the red_trucks name_scope. How do I override the order so it
> because "model_year" instead of "model_year,id"?
should be
> This still gives me the same error because the ''order by
id'' is still
> there from the red_trucks name_scope. How do I override the order so it
> is "model_year" instead of "model_year,id"?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---