Re: Sorting is ignoring spaces

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