I created an SQL script that demonstrates the 'interval' approach to managing hierarchies in SQL. It is based upon approaches presented in Trees in SQL and Nested Intervals with Farey Fractions
... until the collector arrives ...
This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)