Brian Ceccarelli wrote:
> If the words are the same words but letters have different case, then the
> operator is case-sensitive.
> If the words are not the same words, then the operator is case-insensitive
> until the operator reaches the character position in both strings where the
> letters become different.
This is *exactly* how the collation is supposed to work (read: how it is
defined by the C library). It is not a trivial single-pass comparison.
It is definitely not simply a case-sensitive or case-insensitive
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-bugs by date
|Next:||From: Craig Ringer||Date: 2009-08-26 05:20:51|
|Subject: Re: BUG #4996: postgres.exe memory consumption keeps going
|Previous:||From: Jaime Casanova||Date: 2009-08-26 03:40:05|
|Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .|