[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be
From:       Alvaro Herrera <alvherre () commandprompt ! com>
Date:       2009-08-26 4:34:54
Message-ID: 20090826043454.GU12604 () alvh ! no-ip ! org
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]