I have searched the list and understand the need for parentheses when
required by logical or arithmetic operations or subselects.
My question is if it makes a difference to use parentheses when not
logically required, as in the following example where the only logical used
is "and":
select * from log
where
(response >= 200 and response < 300)
and
(port >= 8444 and port <= 8459)
Is there any difference in execution or performance if the parentheses are
present or not? I'm guessing not, but would like confirmation.
select * from log
where
response >= 200
and response < 300
and port >= 8444
and port <= 8459
Thanks!
--
View this message in context:
http://www.nabble.com/use-of-parentheses-when-not-arithmetically-or-logically-required-tp25033803p25033803.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users