In response to Christine Penner <[email protected]>: > 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?
Put the values in numeric fields to begin with and cast to chars as needed. Basically reverse what you're doing. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
