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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users