"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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
