Ejemplos PostgreSQL pivot, PostgreSQL

Language: Layout:

drop table if exists tabla;

create table tabla (
    "desc" varchar(1) not null,
    enero int not null,
    marzo int not null,
    junio int not null
);

insert into tabla ("desc", enero, marzo, junio)
values
('A', 80, 73, 84),
('B', 100, 100, 100);

select * from tabla;

select t."desc", u.*
  from tabla t
  cross join unnest(
    array['ENERO', 'MARZO', 'JUNIO'], 
    array[t.enero, t.marzo, t.junio]
  ) with ordinality as u(mes, valor, sort_no);
  
with cte as (
    select t."desc", u.*
      from tabla t
      cross join unnest(
        array['ENERO', 'MARZO', 'JUNIO'], 
        array[t.enero, t.marzo, t.junio]
      ) with ordinality as u(mes, valor, sort_no)
)
select mes as "desc",
       max(case when "desc" = 'A' then valor end) as A,
       max(case when "desc" = 'B' then valor end) as B
  from cte
 group by mes, sort_no
 order by sort_no;
 
with cte as (
    select t."desc", u.*
      from tabla t
      cross join unnest(
        array['ENERO', 'MARZO', 'JUNIO'], 
        array[t.enero, t.marzo, t.junio]
      ) with ordinality as u(mes, valor, sort_no)
)
select mes as "desc",
       max(valor) filter (where "desc" = 'A') as A,
       max(valor) filter (where "desc" = 'B') as B
  from cte
 group by mes, sort_no
 order by sort_no;
 
drop table tabla;


absolute service time: 0,45 sec