The where clause in sqlite is encoded as a tree

Let's say I have select statement like :

SELECT * from employee where salary = 3+5*4+3;

The tree which takes care of operator precedence is :

                           =
                         /    \
              salary        +
                             /   \
                           3     3
                          /
                         *
                      /    \
                     5     4

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) ?

Kindly give me some pointers towards this tree construction
Thanks a lot for your time.

Regards
Prakash
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to