nested_sets_postgresql

Here you can find the SQL code for the nested sets model written in PostgreSQL 13.3-1.pgdg100+1

The graph form the videos:

stateDiagram-v2
    1/14 --> 2/9
    1/14 --> 10/13
    2/9 --> 3/4
    2/9 --> 5/6
    2/9 --> 7/8
    10/13 --> 11/12

Loading

SQL queries:

• Create nodes table
• Insert tree root
• Add child
• Cut off branch
• Delete node and uplift the descendants
• Create example tree
• Get descendants for any node
• Get leaf nodes
• Finding the depth of the nodes