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
