=?ISO-8859-1?Q?Josu=E9_Maldonado?= <josue@xxxxxxxxxxxx> writes: > I have a table that contains this raw data: > epr_procode | epr_tipo | epr_mes | epr_valor | zert_title > -------------+----------+---------+-----------+---------------------- > 00C188 | VTA | 200309 | 2116.0000 | Venta > 00C188 | CTO | 200309 | 1600.0700 | Costo > 00C188 | VTA | 200311 | 3450.0000 | Venta > 00C188 | CTO | 200311 | 2687.4200 | Costo > I need to display it this way: > TITULO |200309 |200310 |200311 |200312 > -------------+----------+---------+-----------+---------------------- > Venta |2116.0000 |0.0000 |3450.0000 |0.0000 > Costo |1600.0700 |0.0000 |2687.4200 |0.0000 I think the "crosstab" functions in contrib/tablefunc/ might help you. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
