blackwater dev wrote:
I have a table with a mileage column that is a character varying (please
don't ask why :).
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
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
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 :
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 c
