I have thought of doing something like a single table inheritance and it could be done but I thought this might be a little more elegant.
On Tue, Apr 4, 2017 at 2:15 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Apr 3, 2017 at 7:07 PM, Tim Uckun <timuc...@gmail.com> wrote: > >> I am trying to make postgres tables work like an object hierarchy. As an >> example I have done this. >> > > I suspect you are barking up the wrong tree ;) > > You are probably better off incorporating something like the "ltree" type > to encode the taxonomy. > > https://www.postgresql.org/docs/current/static/ltree.html > > I haven't had a chance to leverage it myself but the concept it embodies > is solid. > > David J. > >