2006/7/11, Oisin Glynn <me@oisinglynn.com>:
> 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