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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
