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