Hello z> i wonder is there RECURSIVE select function in sqlite? the background z> for the question are: create table objects (id INTEGER PRIMARY KEY z> AUTOINCREMENT, name text unique) create table tree(id int, child_id z> int, PRIMARY KEY(id, child_id)) i want to draw the whole tree, is there z> good solution for the function?
If you want to store a tree structure in relational tables, then you could read up on things like this: http://articles.sitepoint.com/article/hierarchical-data-database The model on the second page is the one to go for. Hope this helps. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
