Yes, you are right. The error is connected with the version of SQLite. Now I am trying to build DB Browser using SQLite version 3.29.0. Than I have to study your code. Your knowledge and SQL Windows functions are over my scope. Thank for the study material for next weekend :D
On Mon, Sep 2, 2019 at 8:19 PM Keith Medcalf <kmedc...@dessus.com> wrote: > > On Monday, 2 September, 2019 10:34, Petr Jakeš <petr.jakes....@gmail.com> > wrote: > > >Wow, this is HUUUDGE !!! > >Thanks! > >What editor are you using, btw? > > Typically this is on Windows 10 (for Workstations) and the editor I use is > TSE (The Semware Editor). Started using TSE under OS/2 way back and I like > it a lot and have used it ever since. > > >I am on Linux Mint and trying your queries with "SQLite Studio" and > >"DB Browser for SQLite" is throwing syntax error (I think because > >of the rows "lead(timestamp) over (order by timestamp) as next_timestamp," > > Perhaps those are using a version of the SQLite engine that is too old. > Windows functions were added at SQLite Release 3.25.0 on 2018-09-15, > earlier versions of SQLite will not be able to parse that syntax. > > >From the sqlite3 command line your queries run perfectly, no > >problems at all. > > Glad it could provide some help and demonstrate how to sole that > particular problem using pure SQL. > > -- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
