Re: Bug #738: "order by" returning different results in 7.2 and 7.21

pgsql-bugs(at)postgresql(dot)org writes:
> When doing a query that uses the "order by" command, version 7.2 and
> version 7.21 return the records in a different order. All of the
> locale environment variables are identical, and the query is
> identical.

You are showing us the *client*'s locale environment, which has little
to do with what the server's environment is, and even less to do with
what locale initdb was run in. But it's initdb's locale that determines
what the server will consider sort ordering to be. In this case it
looks like the 7.2 server is using en_US (or something like it) while
the 7.2.1 server is pretty clearly using C locale. If you don't like
the setting you'll need to re-initdb ...

regards, tom lane