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?

I got asked this: having this table: # select * from a order by d; t | d ---+---- O | 1 O | 2 O | 3 M | 4 M | 5 M ...

One database that I am monitoring uses a lot of stored procedures. Some of them are fast, some of them are not so fast. I thought - is there a sensible way to diagnose which part of stored procedure take ...

On 12th of February Tom Lane http://archives.postgresql.org/pgsql-committers/2010-02/msg00142.php patch by Hitoshi Harada: Log Message: ----------- Extend the set of frame options supported for window functions.   This patch allows the frame to start from CURRENT ROW (in either RANGE or ROWS mode), and it also adds support ...

A long overdue post about new functionality. At this moment it is no longer such new, as it was committed on 28th of December (yes, I know, I should have written it earlier, Sorry). On this day Tom Lane committed patch ...

Yesterday Tom Lane committed enormous patch, which had commit log: Support window functions a la SQL:2008.   Hitoshi Harada, with some kibitzing from Heikki and Tom. ... and that would be all. I will write more about it, its use cases, and some detailed ...