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
comparison.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
