Re: SQL trees and other nonsense...

Trilobite Trilobite wrote:
> I'm playing with tree structures in SQL.  It's kinda cool and definitely
> a big hack.
>
> Anyway, there are a few things in our database that are more hierarchal
> then they are relational.  The problem I'm working with is accounting,
> as in, "accounts > owners equity > expense accounts > rent > shop rent"

Since when does Expense become a subcategory of Equity? :)

Btw, trees have been discussed so many times. Peruse the archive and
you'll find many bits of wisdom...

As for meself, currently I tend to use MP (materialized path). It's
space expensive but most of my trees are not very deep and MP makes most
queries easy.

After all, NS (nested set) is a special form of MP anyway.

--
dave