Скачать или смотреть How to Remove a Branch in Nested Sets Trees with PostgreSQL (#03)

In this video, we create a stored procedure in PostgreSQL that allows us to cut off a branch from a Nested Sets Tree.
This is a clean way to remove an entire subtree by updating and shifting node boundaries properly.

☕ Buy me a coffee if this helped you:
https://www.buymeacoffee.com/rowadz

📂 Code:
https://github.com/Rowadz/nested-sets...

📘 Recommended References:

Phil Waclawski — Using Hierarchical Data in MySQL (Trees vs Nests):
   • Phil Waclawski: Using hierarchical data in...  

Joe Celko's Trees and Hierarchies in SQL for Smarties:
https://www.amazon.com/Hierarchies-Sm...

📺 Related Playlists:
🐦 Nested Sets Series →    • 🐉 Nested Sets Trees 🐉  
🔱 Graphs & Trees Series →    • 🔱 Graphs & trees 🔱  

⏱️ Timestamps:
00:00 Introduction
01:05 The rules and example
08:02 Running the code