Re: Hierarchical Deletion via a Trigger?

> John Elrick <john.elrick@...> wrote:
> > I'm a bit stumped and was curious if anyone had an elegant solution
> > for this problem.  Assuming the following simplified example, my goal
> > is to cascade the deletes until all parent/child relations have been
> > deleted. The trigger removes the first level, but stops there (I
> > believe this behavior is documented).  I can think of a delete query
> > which would also remove the first level, but am having a brain lock
> > on any single query which would walk a chain of arbitrary length.
>
> It's impossible in pure SQL, unless the DBMS supports special syntax for
> recursive queries, and/or recursive triggers. SQLite supports neither.
> You would have to code the recursion in your host application.