Skip site navigation (1) Skip section navigation (2)

Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ceccareb(at)talusmusic(dot)com
Cc: "'Greg Stark'" <gsstark(at)mit(dot)edu>, "'Brian Ceccarelli'" <ceccareb(at)talussoftware(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .
Date: 2009-08-26 02:18:16
Message-ID: 5598.1251253096@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Brian Ceccarelli" <ceccareb(at)talusmusic(dot)com> writes:
>      After a long and careful study of this, this is a Postgres bug.
> Postgres is boogering up the sort.   The operators < >, and the "order by"
> in the select statement are both case-sensitive and case-insensitive.    It
> is inconsistent.

"Consistency" is not a hallmark of the sort ordering in most non-C
locales :-(.  If this behavior troubles you, use C locale.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Jaime CasanovaDate: 2009-08-26 03:40:05
Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .
Previous:From: Brian CeccarelliDate: 2009-08-26 01:38:31
Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group