3 ms·
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 w
by bmn__ 6y ago
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.