f1 sum_f1 avg_f1 pseudo_recno
10 10 10 1
20 30 15 2
30 60 20 3
40 100 25 4
50 150 30 5
60 210 35 6
I know I can do this by iterating with a plpgsql routine, but there must
be a means simply using SQL
Thanks in advance
Glenn
ps sorry if this isn't the appropriate use for this forum