Incremental sum ?
Domingo Alvarez Duarte <domingo@dad-it.com>
From: domingo@dad-it.com (Domingo Alvarez Duarte)
To: pgsql-sql@postgresql.org
Date: 2001-06-22T08:16:15Z
Lists: pgsql-sql
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 ?