| From: | "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com> |
|---|---|
| To: | "'Alex Pilosov'" <alex(at)pilosoft(dot)com>, "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Changing data types |
| Date: | 2001-09-24 14:53:02 |
| Message-ID: | E15F4B031E17D5118B18009027F67927DAF7@SERVER |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers pgsql-hackers |
>This is not for -hackers.
How so?
>And the answer is "no, you can't". Recreate the table with correct types
>and insert the old values into it.
You're kidding me, right? *prepares to gargle* MS Sql server can. Surely
we can implement this feature or aren't we aiming to go head to head with
commercial rdbms'?
>>On Mon, 24 Sep 2001, Gowey, Geoffrey wrote:
>> I posted this in my last message, but have not heard anything yet so I'm
>> wondering if it was overlooked. I need to know how to change a column
from
>> being say a varchar(9) to an integer. Does anyone know how to change the
>> data type?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-09-24 19:11:04 | Alter project: client or server side? |
| Previous Message | Hiroshi Inoue | 2001-09-24 08:18:20 | Re: [ODBC] New driver options in 7.01.0007 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gowey, Geoffrey | 2001-09-24 14:55:54 | Re: Changing data types |
| Previous Message | Alex Pilosov | 2001-09-24 14:40:23 | Re: Changing data types |