Re: [SQL] Modeling trees with Nested Sets and Nested Intervals

2006-04-09 Thread Michael Glaesemann
On Apr 7, 2006, at 16:28 , Daniel Browning wrote: * Static Hierarchies and Binary Fractions in PostgreSQL, by Michael Glaesemann http://www.grzm.com/fornow/archives/2004/07/10/static_hierarchies This is the most complete out-of-the-box solution I've found. I wrote up Tropashko's method b

[SQL] Modeling trees with Nested Sets and Nested Intervals

2006-04-07 Thread Daniel Browning
I would like to model some hierarchical (tree) data in PostgreSQL. Where can I find high quality Nested Set (or Nested Interval) source code and documentation? I know this question gets asked a lot. To illustrate the point, here is just one thread from each of the last five years: http://arc