Скачать или смотреть How to Delete a Node and Elevate All Descendants in the Nested Sets Tree Model with PostgreSQL (#04)

In this video, we create a stored procedure in PostgreSQL to delete a node from a Nested Sets Tree and elevate all of its descendants.
This pattern is useful when you want to preserve subtrees while removing an intermediate parent node.

☕ 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
00:46 The rules and example
08:53 Running the code
10:35 tschüss