...
Sample SQL to alter tables (PostgreSQL syntax shown):
| Code Block | ||||
|---|---|---|---|---|
| ||||
alter table SA_ADDRESS_CACHE alter column GEOQUALITY type decimal(10,0) using GEOQUALITY::decimal(10,0) ; alter table GX_ADDRESS_CACHE alter column GEOQUALITY type decimal(10,0) using GEOQUALITY::decimal(10,0) ; alter table GD_ADDRESS_CACHE alter column GEOQUALITY type decimal(10,0) using GEOQUALITY::decimal(10,0) ; /* Of course this will fail if your data contains non-numeric values. That shouldn't surprise anyone. */ |
...