October 22nd, 2010 by depesz | Tags: date, function, functions, group by, groups, postgresql, range, sql, time, timestamp | 5 comments »
Today some guy on IRC asked question, which I didn't fully understand, but which could (probably) be summarized: how to group data into 5 minute intervals, based on some timestamp column. Well, it seems trivial (as long as you know how ...
September 12th, 2010 by depesz | Tags: cte, group by, groups, postgresql, rhodiumtoad, window, window functions | 3 comments »
My jabber server had the feature, that it logs all messages that got sent through it. This is pretty cool, and useful. And now, i got asked to use it to create list of conversations. What exactly is this? Whenever I send ...
January 21st, 2009 by depesz | Tags: aggregate, avg, cumulative sum, groups, partitions, pg84, postgresql, rownum, sum, window functions | 2 comments »
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 ...
