> On Aug 16, 2017, at 4:52 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > Is there a chance this isn’t doing what you think it’s doing ? Perhaps it is > evaluating the contents of the brackets first, then getting a true/false > value, and applying the COLLATE to that value.
That would make sense if COLLATE were a normal unary operator, but it isn’t. COLLATE doesn’t apply to a value, it has to be applied _during_ the computation of that value (the “=“ operation) because it affects the way the strings are compared. So it’s really not an operator, more of an annotation of an expression that affects its behavior. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
