Re: [SQL] cumulative sum in aggregate query.

2001-07-11 Thread Tom Lane
David Stanaway <[EMAIL PROTECTED]> writes: > I have a query that gives me x/y data for a graph, and at the moment, > the y data is relative. > EG: > x | y > 1.2 | +1 > 1.9 | 0 > 3.4 | +4 > 5.2 | -2 > 6.7 | -1 > 9.3 | 0 > 11.3 | -1 > Now, I want to convert this result into a r

[SQL] cumulative sum in aggregate query.

2001-07-10 Thread David Stanaway
Hi there, I have a query that gives me x/y data for a graph, and at the moment, the y data is relative. EG: x | y 1.2 | +1 1.9 | 0 3.4 | +4 5.2 | -2 6.7 | -1 9.3 | 0 11.3| -1 Now, I want to convert this result into a result like this: x | y 1.2 |