FAQ doesn't mention ALTER COLUMN TYPE

Started by Michael Fuhrover 21 years ago2 messagesdocs

mike@fuhr.org

over 21 years ago

Question 4.4 in the FAQ, "How do you remove a column from a table,
or change its data type?" doesn't mention 8.0's ability to alter a
column's type with ALTER TABLE tab ALTER COLUMN col TYPE new_type.
Since 8.0 is coming up the FAQ should probably mention this.

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

Bruce Momjian

bruce@momjian.us

over 21 years ago

In reply to: Michael Fuhr (#1)

Re: FAQ doesn't mention ALTER COLUMN TYPE

Michael Fuhr wrote:

Question 4.4 in the FAQ, "How do you remove a column from a table,
or change its data type?" doesn't mention 8.0's ability to alter a
column's type with ALTER TABLE tab ALTER COLUMN col TYPE new_type.
Since 8.0 is coming up the FAQ should probably mention this.

Good point. Done.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073