Earlier today on an internal Heroku group alias there was a dataclip shared. The dataclip listed off some data grouped by a category, there was a reply a few minutes later with a modification to the query that used the crosstab function to pivot directly in SQL. There were immediately several reactions on the list that went something like this: While a mostly simple function in Postgres (there are a few rough edges), it really is all too handy. So here it is in action. Taking some data that l...
