Re: Practical hierarchies

2008-04-29 Thread Baron Schwartz
Bruno, Interesting emails. You might consider talking to Arjen Lentz about his special hierarchical-storage magic. It's still in development, but ... well, I'll let you talk with him about it. Best, Baron On Tue, Apr 29, 2008 at 2:12 PM, Bruno B B Magalhães <[EMAIL PROTECTED]> wrote: > Just co

Re: Practical hierarchies

2008-04-29 Thread Bruno B B Magalhães
Just correcting my self, The hierarchical storage theory is "nested set model", and not "transverse". And also I know that oracle 10g has a hierarchical query, but I am more interested on pure SQL2 theories and solutions. And also, SHOULD (or could) MySQL have some type or recursive query?

Practical hierarchies

2008-04-29 Thread Bruno B B Magalhães
Hi everybody, I would like to discuss there hierarchical storage theory. Currently I have came across 2 types for storing hierarchical data (yes, I´ve read the article at mysql.com, and MANY others sites), but I would like to know your option about the day-to-day usage... I mean I´ve only u