Re: help with nested set
From: paul c <toledobythesea_at_oohay.ac>
Date: Mon, 13 Apr 2009 16:27:44 GMT
Message-ID: <4KJEl.23096$PH1.4433_at_edtnps82>
Date: Mon, 13 Apr 2009 16:27:44 GMT
Message-ID: <4KJEl.23096$PH1.4433_at_edtnps82>
lawpoop wrote:
...
> Suppose I had this adjacency list:
>
> id client_id parent_id level
> 1 1 NULL Corporate
> 2 1 1 Franchise 1
> 4 1 1 Eastern Region
> 5 1 4 New York District
> ...
Can't comment on product techniques but if this were a 'table', I'd wonder how a client can be its own parent. I would have thought some constraint would prevent that. Received on Mon Apr 13 2009 - 18:27:44 CEST