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

    SQLite Nested Set Query?

    Miggl Level 1

      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!