Modelling hierarchy in the relational database
From: abracad <abracad_at_nospam.com>
Date: Fri, 17 Aug 2001 21:08:17 GMT
Message-ID: <3b7d87c0.509669_at_news.freeserve.net>
Date: Fri, 17 Aug 2001 21:08:17 GMT
Message-ID: <3b7d87c0.509669_at_news.freeserve.net>
I am constructing a database to model hierarchy, e.g.
A
|
B
|
C
I envisage a table parent consisiting fields parent, child and would
store records A,B and B,C. Would I also need to store record A,C?
I.e. can SQL act recursively to determina all the children of a given
node (could it retrieve B and C if I queried for the children of A
with only records A,B and B,C stored?)
Many thanks in advance for any help on this