Re: Patch for collation using ICU

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Patch for collation using ICU
Date: 2005-03-30 19:43:23
Message-ID: 200503302143.24154.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-03-30 19:48:00 Re: Patch for collation using ICU
Previous Message Andrew Dunstan 2005-03-30 19:40:11 Re: [HACKERS] contrib/pg_buffercache