[sqlite] using mprint as a global variable inside a query

2015-09-21 Thread Dominique Devienne
On Sun, Sep 20, 2015 at 6:16 PM, E.Pasma wrote: > Based on that I created function mprint() as limited version of mprintf. > It accepts no format, only a value parameter. Furthermore, if called with > no parameter at all, it returns the last printed value. > The problem with such a function is t

[sqlite] using mprint as a global variable inside a query

2015-09-20 Thread E.Pasma
Here is still a follow up of last weeks discussion "Worked in 3.8.9 but no longer in .." which is about the following case: a large table includes a datetime field. From the points in time one wants to report time intervals (from - to). The datetime field is indexed. The fastest solution that w