Following up to my previous question of ordering data sent to an aggregate function.
Can anyone out there think of (or know of) a good way to return multiple values from an aggregate function? For example, if I have an "exponential moving average" function, ema(), I would like to return all of the moving averages that are calculated. This would allow the values to be graphed. It would also let me take the ema() of the ema() (which can be useful at times). I was thinking maybe I could populate a temporary virtual table with the results and then select from it? The extension is for personal use so "hackish" solutions are fine with me. Thanks again for the help, Shane _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
