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

2006/7/11, Oisin Glynn :
> 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