That's great info and thanks for the advice. I'll give it a shot.
On Mon, Jul 22, 2013 at 12:05 AM, Hick Gunter <h...@scigames.at> wrote: > Having written a lot of virtual tables I am quite sure you could write a > virtual table module "analytics" with > > real columns context, order and value and > virtual columns ema, ... for your functions > > You would then > > - INSERT INTO analytics VALUES (context, order, value) ... > > And retrieve functions like > > - SELECT ema,... FROM analytics WHERE context = ... > > Your xUpdate method could store the values in a native table (my_values) > having just the "real columns". > > Your xFilter method would then SELECT FROM my_values WHERE context = > <passed parameter> ORDER BY order. > > Your xColumn method would then return the function values requested, > either stored internally or computed on the fly with the select from > xFilter. > > > > -----Ursprüngliche Nachricht----- > Von: Igor Tandetnik [mailto:i...@tandetnik.org] > Gesendet: Montag, 22. Juli 2013 04:38 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] Multiple return values from aggregate function > > On 7/21/2013 7:13 PM, ss griffon wrote: > > 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? > > Perhaps a virtual table could be pressed into service somehow. I don't > really know much about them beyond the fact that they exist ( > http://www.sqlite.org/vtab.html), but they can manufacture whole > resultsets. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -------------------------------------------------------------------------- > Gunter Hick > Software Engineer > Scientific Games International GmbH > Klitschgasse 2 – 4, A - 1130 Vienna, Austria > FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. If > you have received it in error, you are on notice as to its status and > accordingly please notify us immediately by reply e-mail and then delete > this message from your system. Please do not copy it or use it for any > purposes, or disclose its contents to any person as to do so could be a > breach of confidence. Thank you for your cooperation. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
