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 ...
May 8th, 2008 by depesz | Tags: domain, mysql, plperl, plpgsql, postgresql, timestamp | 6 comments »
MySQL has this nifty/annoying feature/bug of special data type "TIMESTAMP". It is like a DATETIME, but it gets automatically updated whenever you modify the row. I'll try to add the same feature to PostgreSQL.
