Hi there,
It happened to me, too !
Denis Sbragion wrote:
> pgsql=# UPDATE aocc SET controvalore_ord = 320.5 WHERE controvalore_ord = 320.5
> 00 AND oid = 21624;
> ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
> You will have to retype this query using an explicit cast
Strange is that if you try something like this:
pgsql=# update <table> set <field> = <value> where <numeric_field> =
<numeric_constant_without_decimals>;
it works. So, it seems to be a parser difficulty (bug) to correctly determine the
type of a numeric constant
with decimals (like 99.9).
A guru opinion is, still, required !
Bye.
