"Gowey, Geoffrey" wrote:
>
> I posted this in my last message, but have not heard anything yet so I'm
> wondering if it was overlooked. I need to know how to change a column from
> being say a varchar(9) to an integer. Does anyone know how to change the
> data type?
create temptable
as select col_a, col_b, varchar9col_c::int, col_d from originaltable
;
drop table originaltable;
alter table temptable rename to originaltable;
and then create all indexes and constraints.
---------------
Hannu