File store (was Re: Salutations)

[Al B. Snell]

On Mon, 11 Dec 2000, Bill Gribble wrote:

> Right, but that doesn't help you generate a graph of weekly bank
> balances over 5 years.  This is a hard problem, and it's one I think
> needs to be addressed.

Sure it does...

SELECT SUM(amount),date_to_week_num(date) AS week FROM splits WHERE
account=<account ID here> GROUP BY week;

That will produce a "total change" for each week, eg a delta series
instead of a time series, so you have to do some addition in software.

> 
> b.g.
> 

ABS

-- 
                               Alaric B. Snell
 http://www.alaric-snell.com/  http://RFC.net/  http://www.warhead.org.uk/
   Any sufficiently advanced technology can be emulated in software