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

Reply via email to