Re: Changing data types - Mailing list pgsql-hackers

From Gowey, Geoffrey
Subject Re: Changing data types
Date
Msg-id E15F4B031E17D5118B18009027F67927DAF7@SERVER
Whole thread Raw
In response to Changing data types  ("Gowey, Geoffrey" <ggowey@rxhope.com>)
List 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?


pgsql-hackers by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: Changing data types
Next
From: Hannu Krosing
Date:
Subject: Re: Changing data types