In response to Christine Penner <christine(at)ingenioussoftware(dot)com>:
> 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.
In response to
pgsql-general by date
|Next:||From: Christine Penner||Date: 2010-02-24 19:53:42|
|Subject: Re: Cast char to number|
|Previous:||From: Christine Penner||Date: 2010-02-24 19:36:14|
|Subject: Cast char to number|