I was wondering if SQLite supports nested sets, and how to go about constructing a nested set query to get hierarchical data of items in parent-child relationships. For example:
person table has columns id, parent_id, and name.
What would a nested set query look like to get a tree of all people?
I have tried looking for information on nested sets, but it seems to be a scarce subject matter.
Any help or pointers would be great! Thanks!
To update my inquiry, I have found a very detailed article that describes what nested sets are, how they work, and how to implement them!
The following article is written for MySQL: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
And this one adapts the SQL code for SQLite: http://webgeneius.com/blogs.php?mode=view&blog_id=130
I think this should get me going. Just posting in case anyone else is looking for this.