Paul Tilles <Paul(dot)Tilles(at)noaa(dot)gov> writes:
> UPDATE tablename SET value = 0.0 where value!=-9.4;
> ERROR: operator does not exist: smallint !=- integer
> HINT: No operator matches the given name and argument type(s). You may
> need to add explicit type casts.
This is not a bug, this is a feature.
Put a space between, or else use the SQL-standard spelling of not-equals,
ie <>
UPDATE tablename SET value = 0.0 where value!= -9.4;
UPDATE tablename SET value = 0.0 where value<>-9.4;
regards, tom lane