Rows to columns

[Josué Maldonado]

Hello List,
I have a table that look like this:

create table estad
(nprodfk int, cmes char(6), hmes char(5),
nqty numeric(12,2), nsold numeric(12,5),
ncost numeric(12,2));

It contains this data:

insert into estad
values (25,'200402','FEB04',500,5000,2300);

insert into estad
values (25,'200401','ENE04',700,6200,2900);

insert into estad
values (25,'200312','DIC03',950,7100,3000);

insert into estad
values (25,'200311','NOV03',360,3900,1760);

insert into estad
values (25,'200310','OCT03',490,4600,1850);
The problem is I need show the data in this way:

TIPO OCT03 NOV03 DIC03 ENE04 FEB04
--------------------------------------------------------
NQTY 490 360 950 700 500
NSOLD 4600 3900 7100 6200 5000
NCOST 1850 1760 3000 2900 2300

Any idea or suggestion?

Thanks in advanced.
--

Josué Maldonado


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Joe Conway]

Josué Maldonado wrote:

The problem is I need show the data in this way:

TIPO OCT03 NOV03 DIC03 ENE04 FEB04
--------------------------------------------------------
NQTY 490 360 950 700 500
NSOLD 4600 3900 7100 6200 5000
NCOST 1850 1760 3000 2900 2300

Any idea or suggestion?

See contrib/tablefunc for a function called crosstab().

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)