Yes. That works. I think that the parser should work properly either way.
Paul
Bruce Momjian wrote:
Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
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.
Have you tried?
value != -9.4
---------------------------------------------------------------------------
Seems that postgres has a problem parsing a "not equal negative value".
Anybody know if this is fixed in later versions?
Paul Tilles
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
