Sum

Hello All,

I have a single table as:

cod     date       value
---+-------------+-------
1  | 2002-03-12  |  5
2  | 2002-03-13  |  4
3  | 2002-03-13  |  7
4  | 2002-03-14  |  3

... and I would like to do a select that do `partial sums'.

So, for instance, I would like to do a select that returns:

cod     date       value   partial sum
---+-------------+-------+--------------
1  | 2002-03-12  |   5   |      5
2  | 2002-03-13  |   4   |      9
3  | 2002-03-13  |   7   |     16
4  | 2002-03-14  |   3   |     19

As you can see, the row `partial sum' is what I am looking for. Do you
have any idea how can I do it?

Thanks in advance,

Marcelo Pereira

-- Remember that only God and Esc+:w saves.
        __
       (_.\           Marcelo Pereira       |
        / / ___       marcelo@pereira.com   |
       / (_/ _ \__    [Math|99] - IMECC     |
_______\____/_\___)___Unicamp_______________/