Subject: For each record in SELECT
From: Luis =?ISO-8859-1?Q?Maga=F1a?= <joe666@gnovus.com>
Reply-To: joe666@gnovus.com
To: PostgreSQL General <pgsql-general@postgresql.org>,
	PostgreSQL Novice <pgsql-novice@postgresql.org>,
	PostgreSQL SQL <pgsql-sql@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Organization: Gnovus Networks & Software
Message-Id: <1044048077.1380.3.camel@kerberus>
Mime-Version: 1.0
Date: 31 Jan 2003 15:21:17 -0600
Content-Transfer-Encoding: quoted-printable

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=09
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.


--=20
Luis Maga=F1a.
Gnovus Networks & Software.
www.gnovus.com