How to convert a table column to another data type

(Leo Hsu and Regina Obe) As Robert Treat pointed out in our PostgreSQL 8.3 is out and the Project Moves On, one of the features that was introduced in PostgreSQL 8.0 was the syntax of ALTER TABLE sometable ALTER COLUMN somecolumn TYPE new_data_type USING some_function_call_to_cast(somecolumn);

Read More - Register for Free Membership