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-t...@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
