> 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]
-----------------------------------------------------------------------------
