Paul Tilles <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
