Running Totals and other stuff....

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dwindows-1=
252">

Running Totals and other stuff....





Humpfff...Last night I tried posting this and found that<=
BR>
dynamic IP's are now prevented from posting to the list...

Did I miss the announcement?

************************************

Hi,

I keep all of my financial data in Postgresql ( 7.4.2).
My "Check" register records deposits, withdrawals (as amount) , d=
ate,
category and other stuff.

The following sorta works...

SELECT oid, *, (SELECT sum(amount) FROM checks  WHERE x.thedate >=
=3D thedate ) AS total
    FROM checks x
    ORDER BY  thedate,oid ;

The problem is that all transactions on the same date get the total of all<=
BR>
transactions for that date, so the resulting table is only "sorta"=
; a
running total.

If I change the rascal to look like
SELECT oid, *, (SELECT sum(amount) FROM checks  WHERE x.oid >=3D oi=
d ) AS total
    FROM checks x
    ORDER BY  thedate,oid ;

I get the right results, but this relies on the fact the oids in the
check table are currently *sorted* (when the table is sorted by thedate)
at least it appears that way via
a very brief inspection.... I suspect if I deleted a record and added
a record the oids would get out of sequence.

Is there a slick way to tell if a column (say the oids column) is in "=
sorted"
order when the table is sorted by date?

Assuming the oids get out of wack with respect to the date, is it possible<=
BR>
to easily construct a table of the checks sorted by date and then "glu=
e on"
a column of ascending integers so the running total sql statement will
function properly?

Jerry