Change type - Mailing list pgsql-general

From Vladimir S. Petukhov
Subject Change type
Date
Msg-id 200501181901.45464.vladimir@sycore.org
Whole thread Raw
Responses Re: Change type
Re: Change type
List pgsql-general
Hi!

Sorry for my English..

I want to dinamcly change type of column. If possible, of course.
Trivial idia - create new temporary column, try to write value from old columt
to temporarity (if type conersion ok - this made using select/update command
and type conversion checks on client's side), then delete old column, and
rename temporary column..
 But this decision looked quite ill...

Do you have better idea?

--
Я доcтаю из шиpоких штанин,
В котоpых гpажданка одета,
Воcемь ноpмальных. И двадцать один
Запpещенных к ношенью пpедмета!

Now playing: 03 - Lara And Reyes - Exotico.mp3
   AutoGenerated by fortune & xmms...

pgsql-general by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Problem getting sql statement logging to work
Next
From: Thomas F.O'Connell
Date:
Subject: Re: Question on output of VACUUM VERBOSE