Re: [sqlite] Understanding the WITH clause

On Mon, 17 Jun 2019 20:46:41 -0400 Sam Carleton wrote: > It is my view that peace is not something that can be defined with > some words, rather it is a universal experience. "But peace is not merely the absence of this tension, but the presence of justice." -- MLK, Letter from

Re: [sqlite] Understanding the WITH clause

E. Pasma, Thank you, that gives me the results I was looking for, though I am still working on fully understanding why, I have to totally refresh my memory on the details of how the how nested set tree works, once I do, I am sure it will be clear. - OT: about Pax vobiscum I hope

Re: [sqlite] Understanding the WITH clause

On 16-6-2019 19:32, E.Pasma wrote: Message to Luuk: thanks for explaining Pax vobiscum. E. Pasma Thanks for the recursive CTE. Luuk ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/li

Re: [sqlite] Understanding the WITH clause

> Op 15 jun. 2019, om 19:20 heeft Sam Carleton het > volgende geschreven: > > I have kept reading and the next section of the book does away with the > update and simply creates a recursive function. The goal of the function > is to determine the 'weight' of a part by adding up all the subasse

Re: [sqlite] Understanding the WITH clause

On 15-6-2019 18:24, Sam Carleton wrote: Pax vobiscum, Sam Carleton I had to pull up a dictionary to know what Pax (=Peace) you are talking about.. (https://en.wikipedia.org/wiki/Pax_(liturgy)) "In Christian liturgy

[sqlite] Understanding the WITH clause

I am working with a nested set tree and reading through Joe Celko's trees and hierarchies in sql source book to refresh the old brain. In section 4.7.1 of the book he has an example that uses a do while statement. It looks like this concept can be implemented in SQLite by using the WITH clause, b

Re: [sqlite] Understanding the WITH clause

I have kept reading and the next section of the book does away with the update and simply creates a recursive function. The goal of the function is to determine the 'weight' of a part by adding up all the subassemblies * qty. At first I thought this might be easier to convert into SQLite, but upo

[sqlite] Understanding the WITH clause

I am working with a nested set tree and reading through Joe Celko's trees and hierarchies in sql source book to refresh the old brain. In section 4.7.1 of the book he has an example that uses a do while statement. It looks like this concept can be implemented in SQLite by using the WITH clause, b