| Subject | Deleting hierarchical data by using recursive CTE |
|---|---|
| Author | Nols Smit |
| Post date | 2012-02-24T07:02:35Z |
Hi,
I'm using FireBird 2.5
I have a table with hierarchical data.
A column "Parent_Id" that holds the Id ("ID" - the primary key column) of it's parent.
When deleting a row, I want to delete, using recursive CTE, all children (all levels of nesting).
How to do it?
Regards
Nols Smit
[Non-text portions of this message have been removed]
I'm using FireBird 2.5
I have a table with hierarchical data.
A column "Parent_Id" that holds the Id ("ID" - the primary key column) of it's parent.
When deleting a row, I want to delete, using recursive CTE, all children (all levels of nesting).
How to do it?
Regards
Nols Smit
[Non-text portions of this message have been removed]