Tom Lane wrote: >> You cannot specify a conversion function while altering >> a column's type, you'd have to use a new column like this: > > Sure you can; that's the whole point of the USING option. > It'd look something like > > ALTER TABLE test ALTER COLUMN val TYPE varchar(255) USING convert(val); I didn't know that such an option exists. Thanks for the correction! Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
