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