Horton

Order by and leading spaces

Emmanuel GUYOT - InCrEG <emmguyot@wanadoo.fr>

View thread
From: "Emmanuel GUYOT - InCrEG" <emmguyot@wanadoo.fr>
To: <pgsql-bugs@postgresql.org>
Date: 2003-07-06T16:05:22Z
Lists: pgsql-bugs 
Hi,

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.

Anyone has noticed that ? Is there a workaround ?
E.G.

     Emmanuel Guyot
      Co-créateur & gérant  
      8 Rue des Montées
      45100 Orléans
      France  Phone : [33] (0)2 38 56 42 72
      GSM : [33] (0)6 84 62 81 73
      Email : emmguyot@wanadoo.fr
      ICQ : 6945538  
      Web site : http://www.increg.com