Re: numeric type and odbc from access 2000

From: "Shahab Asgharzadeh" <shahab@nwu.edu>

> Access will write the sql as:
> delete from "tablename" where "col1" = 1234 AND "col2" = 'text' AND "col3"
=
> 100.200
>
> ERROR:  Unable to identify an operator '=' for types 'numeric' and
'float8'
>         You will have to retype this query using an explicit cast
>
It is treating "100.200" as float and can't find an '=' operator that
matches numeric with float. You can handle it with

where col3=100.200::numeric

- Richard Huxton