When i am tring to change the column type from character/Varchar to "int" i am getting error like,
ERROR: column "fname" cannot be cast to type "int4"
I can able to change the column type to "int " if the old datatype is double etc.
Even a "int" datatype also i can able to conver to "char"
and why not viceversa....Please tell me where the problem is.
Suggest me what to do to convert a "char" datatype to "int".
pgsql-admin by date
|Next:||From: Andrew Sullivan||Date: 2005-11-15 13:25:01|
|Subject: Re: ERROR: could not read block|
|Previous:||From: Jonah H. Harris||Date: 2005-11-15 06:28:12|
|Subject: Re: [HACKERS] Major Problem, need help! Can't run our|