Sam, Can't answer your question directly, maybe the closure extension is something for you. To read a bit about it: http://charlesleifer.com/blog/querying-tree-structures-in-sqlite-using-python-and-the-transitive-closure-extension/
ingo On 18-6-2019 14:19, Sam Carleton wrote: > My thought process is to do this: > > 1. create a temp table to hold all the descendants of the parent > 2. copy the subordinates (and descendants) into the temp table one at a > time in the new order to get the lft/rgt values correct > 3. Once all the children and descendants are copied into the temp table, > update the lft/rgt values of the source table to get the new order > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
