On Fri, 4 Jul 2003, David Blasby wrote:
> > 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
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).
It turns out our 7.3 database was somehow initd with lo
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
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?
dave
---(end of broadcast)
