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.
[ Parent
| on HN ]