03 - How to Remove a Branch in Nested Sets Trees with PostgreSQL

Опубликовано: 13 Октябрь 2024
на канале: Rowadz
580
16

Buy me a coffee if this is useful 😀
https://www.buymeacoffee.com/rowadz

In this video, I'm showing you how to create a stored procedure that cuts off branches.

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

Phil Waclawski: Using hierarchical data in MySQL trees vs nests:
   • Phil Waclawski: Using hierarchical da...  

Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) 2nd Edition:
https://www.amazon.com/Hierarchies-Sm...

🐦 Nested sets playlist 🐦:
   • 🐉 Nested Sets Trees 🐉  

Graphs and trees playlist:
   • 🔱 Graphs & trees 🔱  


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