running aggregates - Mailing list pgsql-sql

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