ruby-on-rails - 从 Rails 将 float 保存到 PostgreSQL 时出错

Question

我最近刚切换到 PostgreSQL.. 只是想知道这个问题:

PG::Error: ERROR:  column "bathrooms" is of type double precision but expression is of type    character varying at character 161
HINT:  You will need to rewrite or cast the expression.
: INSERT INTO "properties" ("address", "bathrooms", "bedrooms", "city", "country", "created_at",     "description", "name", "state", "updated_at", "zip") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) RETURNING "id"

迁移看起来像这样:

class CreateProperties < ActiveRecord::Migration
 def change
   create_table :properties do |t|
   t.string :name
   t.string :address
   t.string :city
   t.string :state
   t.string :zip
   t.string :country
   t.float :bedrooms
   t.float :bathrooms
   t.string :country
   t.text :description

   t.timestamps
  end
 end
end

Answer 1

我将 float 切换为 decimal，PostgreSQL 现在似乎可以使用隐式转换了？

无论哪种方式，错误都消失了，谢谢