Re: Cast char to number

    Raymond O'Donnell wrote:

> (i)   Create a new column of type numeric or integer as appropriate.
> (ii)  update your_table set new_column = CAST(trim(both ' 0' from
> old_column) as numeric)
> (iii) Drop the old column, as well as any constraints depending on it.
> (iv)  Rename the new column to the same name as the old column
> (v)   Recreate any of the constraints dropped in step (iii).

Or try in a single step:
ALTER TABLE tablename ALTER column column_name
  TYPE numeric USING column_name::numeric;
(replace numeric by the desired type if it's not numeric).

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org