Change type

[Michael Fuhr]

On Tue, Jan 18, 2005 at 07:01:45PM +0000, Vladimir S. Petukhov wrote:

> I want to dinamcly change type of column. If possible, of course.

The FAQ discusses this:

[url]http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.4[/url]

--
Michael Fuhr
[url]http://www.fuhr.org/~mfuhr/[/url]

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

[url]http://archives.postgresql.org[/url]

[Oleg Bartunov]

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: [email]oleg@sai.msu.su[/email], [url]http://www.sai.msu.su/~megera/[/url]
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 [email]majordomo@postgresql.org[/email] so that your
message can get through to the mailing list cleanly

[Vladimir S. Petukhov]

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...

---------------------------(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