2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>:
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?
>
> Paul Tilles
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
Just tested on 8.1.1 I was getting the same error but if i put a space
between the "=" and the "-" it works!
I have already counted 6 very similar answers. Is there some problem
with the list software that prevents people from noticing it has
already been answered?
Regards, Clodoaldo Pinto
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
