From: domingo@dad-it.com
To: pgsql-sql@postgresql.org
Subject: Incremental sum ?
Date: 22 Jun 2001 01:16:15 -0700
Message-ID: <70a76315.0106220016.2a3a6f0b@posting.google.com> (raw)
I have a problem that requires what I call a incremental sum, lets say
I have the folowing table (for simplicity):
table invoices_not_paid(cust_id int, invoice_id int, val numeric, paid
numeric);
with the folowing values:
cust_id invoice_id val paid
----------------------------------
1 23 10.50 3.40
1 34 5.70 0.0
1 67 23.89 4.50
I want show a list like this:
cust_id invoice_id val paid incremental_not_paid_sum
-----------------------------------------------------------------
1 23 10.50 3.40 (10.50 - 3.40) 7.10
1 34 5.70 0.0 (7.10 + 5.70 - 0.0) 12.80
1 67 23.89 4.50 (12.80 + 23.89 - 4.50) 31.19
The operations betwen () are showed only to explain how the
incremental_not_paid_sum is calculated, The operation requires a
reference to a previous column or a partial sum of columns till that
moment, someone has an idea how this can be done using sql ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: domingo@dad-it.com
Subject: Re: Incremental sum ?
In-Reply-To: <70a76315.0106220016.2a3a6f0b@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox