(P)SQL for a sum with constraints

From: Shug Boabby <shug(dot)boabby(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: (P)SQL for a sum with constraints
Date: 2009-04-15 10:09:49
Message-ID: 9508491d0904150309s3d2057a5rc1d81e9206a87ec6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I have a table with 2 bigint columns, let's call them A and B. I need
a query that will allow me to return A alongside the sum of Bs from
rows where A is less than or equal to this row's A. It is best
described with some example data, consider the following:

A B
1 0
2 1
3 0
4 2
5 1

I want to be able to make a query that returns the following rows:

A funkySumB
1 0
2 1
3 1
4 3
5 4

Anyone have any ideas how to do this? I'm able to do it
programmatically, but it's slow. Optimally I'd like to be able to do
this in the DB. As you can see, it's a little trickier that the usual
aggregate function with a GROUP BY and HAVING.

--
Shug

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2009-04-15 10:47:09 Re: (P)SQL for a sum with constraints
Previous Message Dimitri Fontaine 2009-04-15 08:34:37 Re: Disconnected editing - versioning of databases