News for hackers. Stuff that matters.
Re:SQLite now allows multiple recursive SELECT statements in... by bmn__ on Wednesday October 21, 2020 @05:14AM (#24846077)
Still cannot use window functions in recursive queries, e.g. `select row_number() over ()` to enumerate and distinguish paths along the edges of a graph. This works in PostgreSQL, but is an error in SQLite, just tested with preview 3.34.0 2020-10-20. This greatly diminishes the utility of graph querying because only (nearly) trivial queries don't drag window functions into them.
Re:SQLite now allows multiple recursive SELECT statements in... by nikbackm on Wednesday October 21, 2020 @06:01AM (#24846274)
Have you suggested this feature (along with a use case) on the SQLite forum?
Re:SQLite now allows multiple recursive SELECT statements in... by bmn__ on Wednesday October 21, 2020 @05:02PM (#24852144)
It's not my responsibility. Hipp knows he's out of compliance with the standard.