Dennis Cote <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > > What are the precedences. If I say: > > > > x COLLATE seq1 || y COLLATE seq2 > > > > Does that mean: > > > > (x COLLATE seq1) || (y COLLATE seq2) > > > Yes, I believe this is the meaning the standard would take. But notice > that you have a dyadic function (concatenation) with two arguments that > have explicit collations that are not equal (seq1 != seq2), so this > should in fact generate a syntax error. >
I guessed that COLLATE would bind more tightly than || (or any other operator). Note that SQLite has historically resolved an ambiguous collation by choosing the collation of the left operand. I'll need to preserve that behavior in order to maintain backwards compatibility. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
