Home > mailing lists

Re: Order by and leading spaces - Mailing list pgsql-bugs

From	Stephan Szabo
Subject	Re: Order by and leading spaces
Date	July 6, 2003 17:38:26
Msg-id	20030706103445.V59736-100000@megazone23.bigpanda.com Whole thread Raw
In response to	Order by and leading spaces ("Emmanuel GUYOT - InCrEG" <emmguyot@wanadoo.fr>)
List	pgsql-bugs

Tree view

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

pgsql-bugs by date:

From: "Emmanuel GUYOT - InCrEG"
Date: 06 July 2003, 16:03:54
Subject: Order by and leading spaces

From: Shachar Shemesh
Date: 06 July 2003, 19:00:31
Subject: case sensitivity

Re: Order by and leading spaces - Mailing list pgsql-bugs

Previous

Next