Andrew - Supernews wrote:
> On 2007-03-04, William ZHANG <uniware@zedware.org> wrote:
>> Here is the steps to reproduce it in CVS HEAD:
>> backend> select -1 !=-1;
>
> This arguably isn't a bug, because != is not a standard SQL operator, and
> therefore !=- can legitimately be defined as a single operator by the user.
>
I missed the first post and can't seem to search for it - so correct me
if I am missing something.
Isn't the problem here a missing space? != is a valid operator and -1 is
the value you are comparing to. !=-1 is not valid but != -1 is correct
and what I assume you are looking to achieve.
The negation operator goes with the int being negated and is not part of
the comparison operator != the space is needed there to separate the two.
--
Shane Ambler
pgSQL@Sheeky.Biz
Get Sheeky @ http://Sheeky.Biz