I''m new to ruby on rails and am using active record 3 to create some
object models on top of a postgres db.
I have an Environment record with a :name attribute that maps to the
:name column of type :string. When I do Environment.find_by_name(
"abc"
), everything works as expected. However, when I do
Environment.find_by_name( 123 ), my code breaks with the following
error:
ERROR: operator does not exist: character varying = integer
(ActiveRecord::StatementInvalid)
LINE 1: ...nts"."purpose" = ''test'' AND
"environments"."name" = 123)
LI...
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
So my question is, if activerecord knows the type of the :name column
(:string), then why doesn''t it automatically call to_s on the :name
parameter to avoid this issue?
I have a work around right now that overrides find, and explicitly does
this type casting, but I''m guessing there is a cleaner way to achieve
this behavior.
Thanks,
Alex
--
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
