Data format and display

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql general list <pgsql-general(at)postgresql(dot)org>
Subject: Data format and display
Date: 2005-01-20 22:49:56
Message-ID: 41F03594.3090202@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

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

Notice I must display the missing 200310 and 200312 empty data since
users retrieves the info in four months based data set, of course that
data does not exist since there were no trans in those months. Any idea
or suggestion to get it done in Postgresql.

Thanks in advance

--
Sinceramente,
Josué Maldonado.

"Las palabras de aliento después de la censura son como el sol tras el
aguacero."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josué Maldonado 2005-01-20 23:19:21 Re: Data format and display
Previous Message Ian Barwick 2005-01-20 22:45:28 Re: How to manually insert an UTF-8 character into an SQL statement?