Every so often someone asks why sorting behaves irrational. Like here: $ select string from test order by string; string ---------- dean deer de luca depesz de vil dyslexia (6 rows) Why aren't "de luca" and "de vil" together?

On 8th of February, Peter Eisentraut committed patch: Per-column collation support This adds collation support for columns and domains, a COLLATE clause to override it per expression, and B-tree index support. Peter Eisentraut reviewed by Pavel Stehule, Itagaki Takahiro, Robert Haas, Noah Misch ...

On 23rd of September, Heikki Linnakangas committed patch that was written by Radek Strnad (actually committed patch is a stripped-down version of original). What it does? It adds ability to have (finally!) different collation order and character categories for different databases.