It looks like PostgreSQL 9.4 has some really interesting new features. Today I came across a blog post by 2ndquadrant demonstrating the WITHIN GROUP
and FILTER
clauses. I don’t think I’ve entirely got my head round the purpose of WITHIN GROUP
yet, I suspect I need a couple of good real-world examples. The FILTER
clause looks very handy though, I’m sure I’ll be using that when I get the chance.