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
