Full threadchrisfarms·I've implemented similar designs in the past, but found ltree[1] to be much more useful/expressive when it comes to needing to fetch, order and manage lists of hierarchical data.[1] http://www.postgresql.org/docs/9.3/static/ltree.htmlView on HN