suacode

suacode / crosstab.sql

Created November 27, 2016 13:35 — forked from romansklenar/crosstab.sql

PostgreSQL "pivot table" example using tablefunc extension

	CREATE EXTENSION tablefunc;

	CREATE TABLE sales(year int, month int, qty int);
	INSERT INTO sales VALUES(2007, 1, 1000);
	INSERT INTO sales VALUES(2007, 2, 1500);
	INSERT INTO sales VALUES(2007, 7, 500);
	INSERT INTO sales VALUES(2007, 11, 1500);
	INSERT INTO sales VALUES(2007, 12, 2000);
	INSERT INTO sales VALUES(2008, 1, 1000);
	INSERT INTO sales VALUES(2009, 5, 2500);