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.
Well yes it will work if you add a space, but technically the problem is
the query should be written like this:
1 <>-1 or 1 <> -1
Joshua D. Drake
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.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate