Change type

From: "Vladimir S(dot) Petukhov" <vladimir(at)sycore(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Change type
Date: 2005-01-18 19:01:45
Message-ID: 200501181901.45464.vladimir@sycore.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Metnetsky 2005-01-18 20:06:04 Re: Statically linking against libpq
Previous Message Chris 2005-01-18 18:38:24 DBD::Pg behavior for large queries