GitHub - vincentcau/NestedSet: R nested set (original) (raw)

Skip to content

Navigation Menu

• • GitHub Copilot Write better code with AI
  • GitHub Spark New Build and deploy intelligent apps
  • GitHub Models New Manage and compare prompts
  • GitHub Advanced Security Find and fix vulnerabilities
  • Actions Automate any workflow
  • Codespaces Instant dev environments
  • Issues Plan and track work
  • Code Review Manage code changes
  • Discussions Collaborate outside of code
  • Code Search Find more, search less
    View all features
• Explore
  • Learning Pathways
  • Events & Webinars
  • Ebooks & Whitepapers
  • Customer Stories
  • Partners
  • Executive Insights
• • GitHub Sponsors Fund open source developers
  • The ReadME Project GitHub community articles
• • Enterprise platform AI-powered developer platform
• Pricing

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Sign up

Appearance settings

Repository files navigation

• README

NestedSet

R nested set

Tree exemple

result

  id name pathString id_parent total_child_count lft rgt leafCount
1  1    A          A        NA                 1   1  16         5
2  2    B        A/B         1                 2   2   9         3
3  3    D      A/B/D         2                 3   3   4         1
4  4    E      A/B/E         2                 3   5   6         1
5  5    F      A/B/F         2                 3   7   8         1
6  6    C        A/C         1                 2  10  15         2
7  7    G      A/C/G         6                 3  11  12         1
8  8    H      A/C/H         6                 3  13  14         1