Postgres Pro
Downloads
Home   >   mailing lists

Re: Sorting is ignoring spaces - Mailing list pgsql-general

From Tom Lane
Subject Re: Sorting is ignoring spaces
Date
Msg-id 8816.1075590616@sss.pgh.pa.us
Whole thread Raw
In response to Sorting is ignoring spaces  (Daniel Gaudreault <danielg@cadlink.com>)
List pgsql-general
Tree view 
Daniel Gaudreault <danielg@cadlink.com> writes:
> One of our developers came across the fact that postgres is ignoring
> spaces when sorting results from a query.  We are using PGSQL 7.3.4 on
> the backend.  Is there something that needs to be set somewhere to for
> the sort to not ignore spaces?

Sounds like you initdb'd in a non-C locale.  Unfortunately the only fix
is to re-initdb.  You can't change locale on the fly because it affects
the sort ordering of indexes.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Sorting is ignoring spaces
Next
From: Tom Lane
Date:
Subject: Re: Insert question null/not null serial, etc.