ALTER TABLE products ALTER COLUMN power_price DROP DEFAULT;
ALTER TABLE products ALTER COLUMN power_price TYPE bool USING (power_price::boolean);
ALTER TABLE products ALTER COLUMN power_price SET NOT NULL;
ALTER TABLE products ALTER COLUMN power_price SET DEFAULT false;
Postgres gives me this error:
Query failed: ERROR: cannot cast type numeric to boolean
Use:
ALTER TABLE products ALTER power_price TYPE bool USING (power_price::int::bool);
There is no direct cast defined between numeric
and boolean
. You can use integer
as middle-ground. text
would be another candidate for middle ground, since every type can be cast from / to text
. Values have to be 1 / 0
of course.
Better yet, do it all in a single command for better performance and shorter lock time:
ALTER TABLE products
ALTER power_price DROP DEFAULT
,ALTER power_price TYPE bool USING (power_price::int::bool)
,ALTER power_price SET NOT NULL
,ALTER power_price SET DEFAULT false;
Details in the manual about ALTER TABLE
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With