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

Scott Marlowe wrote:
> On Wed, 2006-07-12 at 05:55, Clodoaldo Pinto wrote:
>
>> 2006/7/11, Oisin Glynn <me(at)oisinglynn(dot)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?
>>
>
> 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