Thanks Eduardo, a most interesting link.
On 17 October 2014 05:41, Eduardo Morras <emorr...@yahoo.es> wrote: > On Thu, 16 Oct 2014 09:05:51 +1100 > Michael Falconer <michael.j.falco...@gmail.com> wrote: > > > Hi all, > > > > first off I must start with an apology. I know I'm sort of doing the > > wrong thing here as this question is NOT related to sqlite. It is a > > general SQL question but I ask it here because I have great respect > > for the answers and discussions I have seen on this forum over many > > years. I rarely post myself as there are always several contributors > > who beat me to the answer and often their response is far better than > > mine would have been. I'm not a code leper, I don't need the actual > > SQL just the method really, though a short code example would be well > > received for illustration. > > > > Any thoughts? Suggestions? Missiles? Good approach, bad approach, or > > completely off the grid? I do use sqlite quite a bit, but not on this > > particular project. > > I point you to sqlite closure extension. It may shows you some ideas for > tree implementation and parent/child relations under sql/sqlite. > > http://www.sqlite.org/src/artifact/636024302cde41b2bf0c542f81c40c624cfb7012 > http://www.sqlite.org/src/finfo?name=ext/misc/closure.c > > HTH > > > > > -- > > Regards, > > Michael.j.Falconer. > > _______________________________________________ > > sqlite-users mailing list > > firstname.lastname@example.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > --- --- > Eduardo Morras <emorr...@yahoo.es> > _______________________________________________ > sqlite-users mailing list > email@example.com > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Regards, Michael.j.Falconer. _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users