Re: parent/child relationship in the same table.

From: Jason Diamond <jason_at_injektilo.org>
Date: 19 Nov 2001 08:56:52 -0800
Message-ID: <6768b874.0111190856.38dff697@posting.google.com>

> before we are getting into this lets return to your question. Is it just plain
> hierarchy that is surfacing once in a while in this thread? For hierarchy you
> have plenty of solutions:
>
> 1. Recursive SQL (SQL 99 standard, implemented in DB2)
> 2. Oracle "connect by"
> 3. Incremental evaluation of transitive closure.

It certainly is a hierarchy problem so probably is a FAQ.

I'm using SQL Server so solutions 1 and 2 are automatically ruled out. Do you have any pointers on number 3?

By the way, is there a FAQ document for the group? A quick search on Google didn't find one.

Thanks,
Jason. Received on Mon Nov 19 2001 - 10:56:52 CST