Peter Cai wrote:
PS: the background of this problem is that Postgresql's order by
command depends on the sort result of the OS.
AFAIK PostgreSQL will determine its own locale from the system locale
when it's initdb'ed for the first time, that locale will then be used
for all databases even if
I already did that.
The problem is not that the locale is not correct, but even if it's
correct, the sort order is wrong.
The result provided by pg is the same as the sort command.
It shows that pg use OS's facility to sort string.
Someone told me it's a bug of glibc. So I checked it and found
2 matches
Mail list logo