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