For each record in SELECT - Mailing list pgsql-general

Hi,

I have a question here:

I have a table with this fields:

month
description
amount

now I have to write a query that retrieves the sum of the amount from
the minimum month to the maximum month registered for each diferent
description.

Of course there are cases when a particular description has not record
for all the months in that period.  I mean, suppouse you have this
records:

month    description    amount
-----------------------------------------------
June    description1    100
July    description1    500
August    description1    600
June    description2    300
August    description2    400

how you write a query that outputs something like this:

                June    July    August
------------------------------------------
description1 |    100    500    600
description2 |    300    0    400

My problem is for the 0 value.

I hope I've explained clearly my question.

Thanks for the help.

Best Regards.



--
Luis Magaña.
Gnovus Networks & Software.
www.gnovus.com