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
