On Sun, 6 Jul 2003, Emmanuel GUYOT - InCrEG wrote:
> I've noticed that the 7.3.3 has a strange behaviour were sorting rows
> with leading spaces. It seems that leadings spaces are ignored.
Are you in "C" locale or some other locale and on what OS? Some (many?)
OS locale definitions have collation rules that ignore spaces and/or
symbols. For example, on my redhat box in en_US locale, " b" > "a".
In response to
pgsql-bugs by date
|Next:||From: Stephan Szabo||Date: 2003-07-06 19:34:51|
|Subject: Re: case sensitivity|
|Previous:||From: Emmanuel GUYOT - InCrEG||Date: 2003-07-06 16:05:22|
|Subject: Order by and leading spaces|