PostgreSQL の crosstab サンプル

crosstab_sample.sql

-- PostgreSQL 9.2 で動作確認

create extension tablefunc
;

select *
  from crosstab('
       select year, month, 5
         from generate_series(2009, 2013) as year
   cross join generate_series(1, 12) as month', '
       select generate_series(1, 12)')
    as (year int, jan int, feb int, mar int, apr int, may int, jun int, jul int, aug int, sep int, oct int, nov int, dec int)
;