alter column datatype with cast

Поиск
Список
Период
Сортировка
Искать
От
Klein Balázs
Тема
alter column datatype with cast
Дата
Msg-id
20051229204617.0FBA33E515C@graveyard.mail.t-online.hu
Ответ на
Список
Дерево обсуждения
Re: Final stored procedure question, for now anyway "Guy Rouillier" <guyr@masergy.com>
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"."subjectgroupcondition"  ALTER COLUMN
"param1" TYPE INTEGER
Result    : "ERROR:  column "param1" cannot be cast to type
"pg_catalog.int4""

However when I created an other integer column in the table and updated it
from the text column there was no problem casting the data:
Operation : UPDATE public.subjectgroupcondition SET param2 = cast(param1 as
integer);
Result    : "OK."

Since pg knows that it should cast the data and it can cast it I think I
should have been able to change the datatype in the first instance. Maybe
this behaviour has a good reason but I don't know what it is.

Regards,
SWK

В списке pgsql-general по дате отправления
От: Guy Rouillier
Дата:
От: Joshua Kramer
Дата:
FAQ