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

[Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx>]

On Tue, 2006-07-11 at 12:11, 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.
> 
> Seems that postgres has a problem parsing a "not equal negative value".
> 
> Anybody know if this is fixed in later versions?

Ummmm.  technically, it's not broken.

SQL spec says not equal is specified by:

<>

not 

!=

OTOH, if you put a space in there, it'd work.

UPDATE tablename SET value = 0.0 where value != -9.4;

should work.