If I have a table that is just a single column full of numbers, how can I select all the rows from the table with a second column that is the running tally so far down the result set?
eg:
Num Tally so far 0.3 0.3 1.2 1.5 2.0 3.5 ...
Does this require PL/PgSQL coding? If so, how do you actually construct an arbitrary row for returning? The docs are somewhat unclear on this.
Chris
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
