Yeah, it was my being stupid, I got it going now. Thanks!
On Tue, Apr 22, 2008 at 11:42 AM, Erik Jones <[EMAIL PROTECTED]> wrote: > > On Apr 22, 2008, at 10:34 AM, blackwater dev wrote: > > I have a table with a mileage column that is a character varying (please > > don't ask why :). > > > > I need to do a query where mileage > 500 > > > > select * from cars where mileage>500 > > > > So I need to cast it but everything I try throws an error such as : > > > > ERROR: invalid input syntax for integer: "+" > > > > How can I cast this? > > > > Well, you didn't really give any real information on the format of the > data in your mileage column. However, my guess is that you've got at least > one row with just '+' in the mileage column which is not the same thing as > '+0'. You'll probably need to do a little data cleaning and, once that's > done you should definitely consider switching that to an integer/numeric > data type. > > Erik Jones > > DBA | Emma(R) > [EMAIL PROTECTED] > 800.595.4401 or 615.292.5888 > 615.292.0777 (fax) > > Emma helps organizations everywhere communicate & market in style. > Visit us online at http://www.myemma.com > > > >
