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