On Mon, Apr 3, 2017 at 7:07 PM, Tim Uckun <timuckun(at)gmail(dot)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.