I have 2 columns in a PostgreSQL table. The
mac_address_temp column is for migration from character type to MAC-address type:
mac_address | macaddr | mac_address_temp | character varying(17) |
I want to migrate data from mac_address_temp to mac_address, but there is some data that can't be cast as
mac_address | mac_address_temp -------------+------------------ | AAB5:4f27:e299 | AAB54f27e299 UPDATE mactable SET mac_address = CAST(mac_address_temp as macaddr); ERROR: invalid input syntax for type macaddr: "AAB5:4f27:e299"
Is there a way to ignore where
CAST doesn't work and still update rest of the table?