Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group