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.johnston@xxxxxxxxx> 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.I haven't had a chance to leverage it myself but the concept it embodies is solid.David J.
