Re: sql question - hierarchy
From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: 26 Mar 2003 09:48:22 -0800
Message-ID: <6dae7e65.0303260948.4013097_at_posting.google.com>
Date: 26 Mar 2003 09:48:22 -0800
Message-ID: <6dae7e65.0303260948.4013097_at_posting.google.com>
"LokalST" <stbest001_at_hotmail.com> wrote in message news:<b5ru1f$2bi$1_at_sunce.iskon.hr>...
[...]
> Tnx Lennart but unfortunatelly I'm fighting with Oracle SQL :-( and that
> kind of query is not supported in it.
> But, tnx u anyway.
Well, I wasnt trying to convert you ;-) However, you could try some other alternatives:
- Nested set (google for Celko and Nested set).
- Store the relation Ancestor in a separate table, and when you add, delete and move people around maintain that table as well.
You might find this article interesting
http://www.dbazine.com/tropashko4.html
HTH
/Lennart
Received on Wed Mar 26 2003 - 18:48:22 CET