Daniel Gaudreault <danielg(at)cadlink(dot)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
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2004-01-31 23:15:32|
|Subject: Re: Insert question null/not null serial, etc. |
|Previous:||From: Alvaro Herrera||Date: 2004-01-31 22:54:04|
|Subject: Re: Sorting is ignoring spaces|