After running a migration I noticed that rails is changing the specified
decimal data type in PostgreSQL. Is there a reason for that?
According to this post:
I found that there is a slight difference between decimal type and
NUMERIC must be exactly as precise as it is defined — so if you define 4
decimal places, the DB must always store 4 decimal places.
DECIMAL must be at least as precise as it is defined. This means that
the database can actually store more digits then specified (due to the
behind-the-scenes storage having space for extra digits). This means the
database might store 1.00005 instead of 1.0000, affecting future
class CreateBooks < ActiveRecord::Migration
create_table :books, id: :uuid do |t|
After running this migration, the column price is of numeric type
instead of decimal.
Any feedback is appreciated