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

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

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
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 03:40:05
Message-ID: 3073cc9b0908252040u26f1d1acp7dc89f9aea3dd66@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Aug 25, 2009 at 8:38 PM, Brian
Ceccarelli<ceccareb(at)talusmusic(dot)com> 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 completely non-sense. can you present a test case that proves
what you're claiming?

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2009-08-26 04:34:54
Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .
Previous:From: Tom LaneDate: 2009-08-26 02:18:16
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