Scott Marlowe wrote:
On Wed, 2006-07-12 at 05:55, Clodoaldo Pinto wrote:
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?
I think it's just the vagaries of the internet. By the time any one of
us saw the other's response, we'd already written it. Plus, it's an
easy question to answer, so there was little delay in thinking up a
response for most folks.
It's better than some other mailing lists I've been on, where such
questions receive thundering silence for days on end... :)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
I was somewhat confused it took my response about 5 hours to appear. I
looked at the headers when my post eventually appeared it was odd. Other
times the posts seem very quick. I seem to think that almost all the
responses took a long time to appear.
Oisin
