On Thu, Aug 1, 2013 at 1:06 PM, Filipe Oliveira <filipeolive...@gmail.com>wrote:
> Hi, > > Here http://www.sqlite.org/lang_expr.html says that "The COLLATE operator > is a unary postfix operator that assigns a collating > sequence<http://www.sqlite.org/datatype3.html#collation> to > an expression. The COLLATE operator has a higher precedence (binds more > tightly) than any prefix unary operator or any binary operator.". > > But checking the parser.y file the bitwise not operator seems to have a > higher precedence than COLLATE. > > parser.y - line 227 > %left OR. > %left AND. > %right NOT. > %left IS MATCH LIKE_KW BETWEEN IN ISNULL NOTNULL NE EQ. > %left GT LE LT GE. > %right ESCAPE. > %left BITAND BITOR LSHIFT RSHIFT. > %left PLUS MINUS. > %left STAR SLASH REM. > %left CONCAT. > %left COLLATE. > %right BITNOT. > > So, which one is correct? > The parser. I'll fix the documentation. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users