Re: [GENERAL] alter column datatype with cast

2005-12-29 Thread Michael Fuhr
On Thu, Dec 29, 2005 at 09:46:10PM +0100, Klein Balzs wrote: > I had to change the datatype of a column from text to integer. The column > contained integers (obviously stored as text). > > When I tried to change the datatype of the column I got an error message > saying that the column can not be

[GENERAL] alter column datatype with cast

2005-12-29 Thread Klein Balázs
I had to change the datatype of a column from text to integer. The column contained integers (obviously stored as text). When I tried to change the datatype of the column I got an error message saying that the column can not be cast to integer: Operation : ALTER TABLE "public"."subjectgroupcondit