On 23rd of December, Tom Lane committed patch: Support ordered-set (WITHIN GROUP) aggregates. This patch introduces generic support for ordered-set and hypothetical-set aggregate functions, as well as implementations of the instances defined in SQL:2008 (percentile_cont(), percentile_disc(), rank(), dense_rank(), percent_rank(), cume_dist()). We also added mode() ...

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

Let's imagine simple situation - you have table of objects (each with id), and you want objects 3, 71, 5 and 16. And in that order! How to do it?

On 15th of December Tom Lane committed patch by Andrew Gierth (aka RhodiumToad), which adds interesting capability: Log Message: ----------- Support ORDER BY within aggregate function calls, at long last providing a non-kluge method for controlling the order in which values are fed to ...