Andrew - Supernews wrote:
On 2007-03-04, William ZHANG <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
