May 13th, 2010 by depesz | Tags: changes, count, lag, nullif, postgresql, rank, tnt, window functions | 3 comments »
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 ...