On Fri, Jun 10, 2011 at 1:57 PM, Bill Moran <wmoran@xxxxxxxxxxxxxxxxx> wrote: > I don't think ALTER COLUMN TYPE will implicitly convert from varchar > to INT. > > Try: > ALTER TABLE reference > ALTER COLUMN color > TYPE INT > USING CAST(color AS INT); Your command suggestion worked perfect but can you explain why yours worked and mine didn't? I've never used 'USING CAST' command before. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
