> I believe SQLite uses the same operator precedence as the SQL standard > requires. If I am wrong about that, please correct me and I will > change it.
As I interpret the SQL92 standard (which I believe SQLite tries to follow), I think all comparison operators should have the same level of precedence: <comp op> ::= <equals operator> | <not equals operator> | <less than operator> | <greater than operator> | <less than or equals operator> | <greater than or equals operator> Nothing in the wording of the standard that I can find suggests that NE and EQ have a different precedence level from the other 4 comparison ops: %left IS MATCH LIKE_KW BETWEEN IN ISNULL NOTNULL NE EQ. %left GT LE LT GE. The following binary bitwise operators are outside of the SQL92 standard: <<, >> & | but many SQL implementations tend to adopt the C precedence rules in this case. Principle of least astonishment, I imagine. ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------