Palle Girgensohn wrote:
> Just a comment: ORDER BY *is* already case sensitive on Linux, since
> its strcoll ignores case. I doubt very much it violates SQL
> standards.
The behavior of collation sequences is implementation-defined. So as
long as you can put the behavior in words, it should be OK.
It would seem, however, that the behavior of a certain locale name
should be the same with or without ICU, so perhaps some locale renaming
might be needed, but that is speculation on my part.
> > How does your patch interact with the ability to use indexes for
> > anchored LIKE or regex (i.e. can "name LIKE 'start%'" still use
> > index) ?
> The problem, AFAIK, has to do with the nature of (some) locales, not
> with a specific implementation of collation.
Yeah, pretty much the whole point of that code is to avoid collating
stuff.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/