Re: Problem with PostgreSQL string sorting

Peter Geoghegan <pg(at)bowt(dot)ie> writes:
> The behavior of each collation comes from the operating system's own
> libc, except for the C collation, which is based on the ordering
> implied by strcmp() comparisons. Generally, most implementations have
> the behavior you describe, in that they assign least weight of all to
> caseness and whitespace, and somewhat more weight to punctuation. I
> don't think that there is much that can be done about it in practice,
> though in principal there could be a collation that has all the
> properties you want.

I believe most versions of libc use declarative specifications of locale
properties, so if you wanted to spend some time learning the language in
which those are written, you could make and install a locale that acts
like you want. It's possible there's one out there already, because
a lot of people seem to want that.

In any case, this is not a bug, this is a feature request; and it's not
even for a Postgres feature, it's for a libc feature.

regards, tom lane