Re: Changing data types

"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