[thelist] [DB Design] Recursive Directory Structure

[Ken Kogler]

> You can do this quite easliy if you approach it as a recursive data
> structure. You need to have a way to point one row at another in the
> same table (child to parent) and to determine when you've reached
> home.

Yeah, but the performace hit scares me -- this table would be pretty
big, and the server isn't the most robust piece of hardware I own. :)

Is there a way to do this with JOINing the table on itself?

> I'm hungry.

Ditto. Why do you think I picked that example? :)