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   Branch ------ master