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 给我返回了以下错误信息:
查询失败:ERROR: 无法将数字类型转换为布尔类型
text
作为过渡。考虑:SELECT 12::text::bool;
->ERROR: invalid input syntax for type boolean: "12"
。因此,可以选择在转换时是否严格要求... - Erwin Brandstetter