1 Reply Latest reply on May 24, 2010 8:17 PM by Miggl

    SQLite Nested Set Query?


      Hi All,


      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!