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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
