Mysql has bitwise & before | https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
TSQL (MSSQL) has them equal. https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql Oracle doesn't have bitwise & and | https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm SQL Standard http://web.cecs.pdx.edu/~len/sql1999.pdf doesn't seem to have math operators... and the precedence tables are described in longhand without a simple table.... DateTimes have math operators "Operations on numbers are performed according to the normal rules of arithmetic, within implementation-defined limits, except as provided for in Subclause 6.26, ‘‘’’." 'normal rules of arithmetic' how vague https://en.wikipedia.org/wiki/Order_of_operations#Programming_languages (a separate section on rules of programming langauges) also on this page ... - In the United States, the acronym *PEMDAS* is common. It stands for *P* arentheses, *E*xponents, *M*ultiplication, *D*ivision, *A*ddition, *S* ubtraction. "Most common in the UK, India and Australia[11] <https://en.wikipedia.org/wiki/Order_of_operations#cite_note-12> are *BODMAS* meaning "B"rackets, "O"f or "O"rder, "D"ivision, "M"ultiplication, "A"ddition and "S"ubtraction. Nigeria and some other West African countries also use *BODMAS*. Similarly in the UK, *BIDMAS* is used, standing for "B"rackets, "I"ndices, "D"ivision, "M"ultiplication, "A"ddition and "S"ubtraction." which doesn't account for & or | operations... so... _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
