Boolean Arithmetics

From: Alberto Micol <Alberto.Micol-at-eso.org>
Date: Thu, 04 Mar 2004 11:13:00 +0100

Dear All,

Just to repeat that the SQL order of operation is not up to the end-interpreter
nor it is from left to right, but there is a clear precedence.

In SQL-92 first the parenthesis are evaluated, then the precedence is: IS, NOT, AND, OR and left to right for operators at the same level

Alberto
PS: That was already mentioned in http://www.ivoa.net/forum/voql/0321.htm Received on 2004-03-04Z11:13:18