On 8/22/2013 3:12 PM, Simon Slavin wrote:

On 22 Aug 2013, at 8:04pm, Igor Tandetnik <i...@tandetnik.org> wrote:
[snip]

I pretty much agree with everything you wrote there.  But it has nothing to do 
with my original objection which was the explicit use of a COLLATE operator 
inside an expression.

If you agree with everything I wrote, then I don't understand what exactly you find wrong with the explicit use of a COLLATE operator inside an expression. Is there something that can be done your way but can't be done the current way? Is there some bad outcome that's possible the current way but prevented your way? Do you just prefer your (as yet unspecified) syntax on purely aesthetic grounds?

Let's assume, for the sake of argument, that the case of "(x collate A) = (y collate B)" and similar instances of mismatched collations are made an error (I've conceded that it may be a good idea, so there's no reason to re-tread this ground).
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to