Oracle knows a clause called " connect by ..." where you can have "parent"-nodes and "siblings" and so on to construct hierarchical e.g. part lists
My understanding is that sqlite does not support this. S. -----Ursprüngliche Nachricht----- Von: zeal <[email protected]> Gesendet: 17.05.2010 15:40:32 An: [email protected] Betreff: [sqlite] recursive select in sqlite dear Sqlite group, i wonder is there RECURSIVE select function in sqlite? the background for the question are: create table objects (id INTEGER PRIMARY KEY AUTOINCREMENT, name text unique) create table tree(id int, child_id int, PRIMARY KEY(id, child_id)) i want to draw the whole tree, is there good solution for the function? thanks. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________________________ NEU: WEB.DE DSL für 19,99 EUR/mtl. und ohne Mindest-Laufzeit! http://produkte.web.de/go/02/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
