SanjayK schrieb:
Since SQLite is perfect for use in single-user desktop utility applications
and since such applications typically store hierarchial data (tree) in a
single table, it would be nice to have support for special features like
connect by of oracle.
See:
http://www.adp-gmbh.ch/ora/sql/connect_by.html
--
View this message in context:
http://www.nabble.com/Managing-trees-in-the-database-t1135555.html#a2974277
Sent from the SQLite forum at Nabble.com.
Depending on your goals, this concept might give you another solution:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
As the code examples are for mysql, you need to adapt it a bit.
HTH
Philipp