While i haven't needed this functionality, i have been thinking about
how it could be solved in a performant way.
IMHO, the solution would be to create a virtual table that takes, for
example, as input a query that produces the following rows:
C1 | C2
a1 | b1
a2 | b2
a3 | b3
and
On Wed, Sep 19, 2012 at 12:51 PM, joe.fis...@tanguaylab.com
wrote:
> Too bad SQLite doesn't yet support SQL Window Functions.
>
> Are there any SQLite Extension Libraries that support "SQL:2003 type Window
> Functions"?
> I specifically need LEAD and LAG to calculate an
Mohd Radzi Ibrahim wrote:
> On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik wrote:
>
>> On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote:
>>
>>> Too bad SQLite doesn't yet support SQL Window Functions.
>>>
>>> Are there any SQLite Extension
> > Could it not be done with inner select of ROWID-n and ROWID+n to get the
> > LEAD and LAG row ?
> >
> > select
> > logtime as timeNow,
> > (select logtime from logtable where rowid=a.rowid-1) as timeBefore,
> > (select logtime from logtable where rowid=a.rowid+1) as timeAfter
>
On Wed, Sep 19, 2012 at 7:10 PM, Mohd Radzi Ibrahim wrote:
> On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik wrote:
>
>> On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote:
>>
>>> Too bad SQLite doesn't yet support SQL Window Functions.
>>>
>>> Are
On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik wrote:
> On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote:
>
>> Too bad SQLite doesn't yet support SQL Window Functions.
>>
>> Are there any SQLite Extension Libraries that support "SQL:2003 type
>> Window Functions"?
>>
On 9/19/2012 12:51 PM,
joe.fis...@tanguaylab.com wrote:
Too bad SQLite doesn't yet support SQL Window Functions.
Are there any SQLite Extension Libraries that support "SQL:2003 type
Window Functions"?
I specifically need LEAD and LAG to calculate an event integer timestamp
delta between
Too bad SQLite doesn't yet support SQL Window Functions.
Are there any SQLite Extension Libraries that support "SQL:2003 type
Window Functions"?
I specifically need LEAD and LAG to calculate an event integer timestamp
delta between consecutive rows.
I've played with some self-join code but
8 matches
Mail list logo