X-Original-To: pgsql-general@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 4DC314774B2; Fri, 31 Jan 2003 22:39:54 -0500 (EST)
Received: from MAIL.nucleus.com (mail1.nucleus.com [207.34.101.2])
	by postgresql.org (Postfix) with ESMTP
	id 1220E4763CB; Fri, 31 Jan 2003 21:37:39 -0500 (EST)
Received: from dsl-mr-209-115-166-163-cgy.nucleus.com (unverified
	[209.115.166.163]) by MAIL.nucleus.com
	(Vircom SMTPRS 2.0.241) with ESMTP id <B0076549938@MAIL.nucleus.com>;
	Fri, 31 Jan 2003 19:37:37 -0700
From: "Andrew J. Kopciuch" <akopciuch@bddf.ca>
Reply-To: akopciuch@bddf.ca
Organization: BDDF Consulting
To: joe666@gnovus.com, PostgreSQL General <pgsql-general@postgresql.org>,
	PostgreSQL Novice <pgsql-novice@postgresql.org>,
	PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: [SQL] For each record in SELECT
Date: Fri, 31 Jan 2003 19:36:17 -0700
User-Agent: KMail/1.5
References: <1044048077.1380.3.camel@kerberus>
In-Reply-To: <1044048077.1380.3.camel@kerberus>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Disposition: inline
Message-Id: <200301311936.18611.akopciuch@bddf.ca>
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/1629
X-Sequence-Number: 36750

On Friday 31 January 2003 14:21, Luis Maga=C3=B1a wrote:
> 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.
>