Re: '_' < '5' -- different answer on 7.2 and 7.3 - Mailing list pgsql-hackers

On Fri, 4 Jul 2003, David Blasby wrote:

> I noticed a change between our 7.2 and 7.3 postgresql database.
>
> On 7.2:
>
> template1=>  select '_' < '5';
>   ?column?
> ----------
>   f
> (1 row)
>
>
>
> On 7.3:
>
> template1=#  select '_' < '5';
>   ?column?
> ----------
>   t
> (1 row)
>
>
> Any reason for this change?

My first guess would be that you're not running in "C" locale
on the 7.3 system.  I get false on my 7.3.1 system in C locale,
but if I compare the two strings in C using en_US for example I
seem to get results like the above ('_'<'5' is true).