On Tue, 18 Jan 2005, Vladimir S. Petukhov wrote:
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?
hmm,
you may use generic type like 'varchar' to store your data
-- Я доcтаю из шиpоких штанин,В котоpых гpажданка одета,Воcемь ноpмальных. И двадцать одинЗапpещенных к ношенью пpедмета! Now playing: 03 - Lara And Reyes - Exotico.mp3 AutoGenerated by fortune & xmms... ---------------------------(end of broadcast)---------------------------TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
