Among other imporvements, this version supports window functions, recursive queries and common table expressions (CTE’s).
Despite being a minor release (accoring to the version numeration), this version can become quite a milestone, since these features make developer’s life much, much easier.
Let’s check how efficienly these features are implemented.
To do this, I’ll take some tasks that I wrote about in the previous blog posts and try to reimplement them using new PostgreSQL features.
I’ll start with quite a common task of flattening the intersecting timespans which I wrote about in this article:

Mas:

http://explainextended.com/2009/07/14/flattening-timespans-postgresql-8-4/