Subject Re: [firebird-support] Function - what is it called
Author Mike Ro
On 23/01/2015 10:25, Michael.Vilhelmsen@... [firebird-support] wrote:
 

Hi


I am looking for a function which are able to add values from a table as records are fetched.

Something like this:


Value Calculated value 

1 1

2 3

3 6

4 10

5 15

The calculated value is just the sum of all previous values of VALUE.

Whats the name of such function in english and Firebird?

This is sometimes called the Triangular Number, see

http://en.wikipedia.org/wiki/Triangular_number