Search Postgresql Archives

Re: (P)SQL for a sum with constraints

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux