[GENERAL] Cast char to number

[Christine Penner]

I have a character field I want to change to a number. The values in 
that field are all numbers that may or may not be padded with spaces 
or 0's. What is the best way to do that?

Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com 


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general