Andreas Seltenreich <andreas+pg@gate450.dyndns.org> writes:
>> Klaus Ita schrob:
>>> this is also wrong (There should be 'Unter' and then 'U:berflieger'
>>> [Überflieger]). so is this a libc bug?
> I think I got your point now. Libc appears to be using iso-14651
> sorting for all "de" locales. I'm afraid you will have compile a
> customized locale to depart from that.
I wouldn't call it a libc bug, but a bug in the locale definition.
In any case it doesn't appear to be Postgres' problem --- if we sort
the same way "sort" does under the same locale setting, then we are
doing what we expect.
I think at this point Klaus needs to find some people who know about
hacking locale definitions. I sure don't know enough about them to
help further. Is there a libc mailing list anywhere?
One thing I do know --- if you install a new version of the locale
Postgres is using, you'd better re-initdb, or at least REINDEX all
your indexes on textual columns. Changing sort order is equivalent
to making such indexes corrupt.
regards, tom lane
