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 ...
July 13th, 2009 by depesz | Tags: aggregate, dim, irc, plpgsql, postgresql, rhodiumtoad, sql | 1 comment »
Today, on irc (#postgresql on freenode.net) Dim mentioned about writing median calculation code. It got me thinking, and consequently writing my version of median calculation code.
