Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 1

Summary

In this article we implemented an n-level nested tree, including an SQL schema to represent the tree as well as example queries for looking up the data.

In the next article, we’ll implement the nested tree in PHP.

• Download a PDF version of this article
• View or post comments for this article
• Browse similar articles by tag: MySQL, PHP, PostgreSQL
• Read related articles:
  • Implementing An N-Level Nested Tree In PHP And PostgreSQL Appendix
  • Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 2