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

Reply via email to