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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-26 04:34:54 Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .
Previous Message Tom Lane 2009-08-26 02:18:16 Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .