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? Thanks in advance, Filipe Oliveira. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
