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);