Re: '_' < '5' -- different answer on 7.2 and 7.3

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).