Re: doesn't recognize "!=-" (not equal to a negative value)

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Paul Tilles <Paul.Tilles@xxxxxxxx> 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