From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: (P)SQL for a sum with constraints |
Date: | 2009-04-15 10:56:48 |
Message-ID: | 20090415105648.GA7355@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to Shug Boabby :
> 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
>
wait for 8.4:
test=# select * from shug ;
a | b
---+---
1 | 0
2 | 1
3 | 0
4 | 2
5 | 1
(5 rows)
test=# select a, sum(b) over (order by a) from shug ;
a | sum
---+-----
1 | 0
2 | 1
3 | 1
4 | 3
5 | 4
(5 rows)
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
From | Date | Subject | |
---|---|---|---|
Next Message | Peeyush | 2009-04-15 10:57:50 | need information |
Previous Message | Ow Mun Heng | 2009-04-15 10:51:52 | pg_reorg -> Anyone has any experience with it? |