ActiveRecord - return array of only ids?

Is it possible to get ActiveRecord to run a query and return an array
of only the ids of the rows that matched? It seems to insist on giving
me back an array of objects, even if I specify ":select => 'id'" as
part of my find(). I don't want to have to loop over the objects
getting all the ids if I don't have to. Can't AR be coaxed into
returning ids and only ids?

I've pored over documentation and searched the web and I haven't
really come up with much. Thought I'd try you all.

Thanks,
-Bill

You'll need to drop back to the raw adapter for a custom query. #find
is only interested in dealing with ActiveRecord instances.

Foo.connection.select_values "SELECT id FROM foos ..."

Object.find(:all, :select => 'id') works but I don't think that is
what you really want.

You want [1,2,3,4,5], correct?

If so, you can do Object.find(:all,:select=>'id').map {|x| x.id}

Object.find(:all, :select => 'id') works but I don't think that is
what you really want.

You want [1,2,3,4,5], correct?

If so, you can do Object.find(:all,:select=>'id').map {|x| x.id}

You can alos use symbol to proc trick here:

Object.find(:all,:select=>'id').map(&:id)

Regards,
Rimantas

Excellent suggestions, everyone. Thank you!

How do I find out about the magic of "map"?

thanks,

Thufir

http://www.ruby-doc.org/core/classes/Enumerable.html#M003159

http://tech.rufy.com/2006/11/functional-programming-in-ruby.html

Should anyone else come across this, another way to refine this further
is:

Object.pluck(:id)

This will produce your array of ids.

More here
http://guides.rubyonrails.org/active_record_querying.html#pluck