Does anyone know how to create a migration to alter a column type to decimal(10,2)

That should use set_column_type ROM::SQL.migration do change do alter_table :orders do set_column_type :price, "decimal(10,2)" end end end

±------------±--------------±-----±----±--------±---------------+ | Field | Type | Null | Key | Default | Extra | ±------------±--------------±-----±----±--------±---------------+ | id | int | NO | PRI | NULL | auto_increment | | category_id | int …

Side note: this is not germane to your question, but I’ve spent a lot of time working on billing systems. I would not recommend using a plain decimal(10,2) for this, although that is better than a floating point. Although PostgreSQL has monetary types , in my experience the best way to store money i…

migration for column type decimal(10,2)

questions

alassek December 6, 2024, 11:22pm 2

What is the current schema for that column?

Topic		Replies	Views
Use postgis datatypes questions	0	1145	May 18, 2017
Hanami Docs error (postgres UUID & Entity) issues	1	1426	April 18, 2017
Trying to add custom type to schema with Types.define(..) raises no method error issues	7	30	February 20, 2026
Default to UUID orimary key via app settings proposals	0	1108	August 6, 2018
dry-types incompatible with later version of chamber gem issues	1	90	January 9, 2026

migration for column type decimal(10,2)

Related topics