Re: Order by and leading spaces

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Emmanuel GUYOT - InCrEG <emmguyot(at)wanadoo(dot)fr>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Order by and leading spaces
Date: 2003-07-06 17:37:52
Message-ID: 20030706103445.V59736-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2003-07-06 19:34:51 Re: case sensitivity
Previous Message Emmanuel GUYOT - InCrEG 2003-07-06 16:05:22 Order by and leading spaces