On 10 Nov 2014, at 9:40am, Prakash Premkumar <prakash.p...@gmail.com> wrote:
> If I am constructing this tree for where clause by myself, should i take > the operator precedence in to account while constructing it or will sqlite > take care of precedence,given any tree (i.e constructing it with out taking > precedence into account) ? SQLite takes operator precedence into account, using the precedence described in the section "Operators" on this page: <https://www.sqlite.org/lang_expr.html> I found that by Googling 'SQLite precedence', selecting the top hit, then searching for 'precedence' on the page. If you want any other precedence than the one this page describes, you should to use brackets. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
