Re: order by text-type : whitespaces ignored?? - Mailing list pgsql-general

From Richard Huxton
Subject Re: order by text-type : whitespaces ignored??
Date
Msg-id 457FBF89.6000608@archonet.com
Whole thread Raw
In response to order by text-type : whitespaces ignored??  (peter pilsl <pilsl@goldfisch.at>)
Responses Re: order by text-type : whitespaces ignored??  (peter pilsl <pilsl@goldfisch.at>)
List pgsql-general
peter pilsl wrote:
>
> I just get my mind crossed here:
>
> I do a simple select with order on a text-type. In my opinion entries
> with leading spaces should be either first (or maybe last) in the list.
> But in my select the whitespace just seems to be ignored:

That'll be down to your locale settings. You'll need to re-initdb to
change them I'm afraid. It's locale=C that you want.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: peter pilsl
Date:
Subject: order by text-type : whitespaces ignored??
Next
From: Rafal Pietrak
Date:
Subject: A VIEW mimicing a TABLE