On 24/02/2010 21:42, Christine Penner wrote: > This is what I did. > > set all blank columns to '0' because they were causing errors. > alter table T alter column a type integer using a::integer > > That worked perfectly. Glad you got sorted. Bill's advice upthread is worth taking on board - if you're in a position to do so, make sure that numbers are stored as numbers rather than text, and you'll save yourself all sorts of wacky grief. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general