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).
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
