>
I agree with the barking up the wrong tree, building a physical tree in tables doesn't sound rightgiven that you will have to create a new branch in the tree when a new version/variation of ubuntu comes out.
This doesn't bother me that much. If can say create table ubuntu_17_04 inherits ubuntu and have it return all the parents data as I described it would be awesome
>Also think about how you are going to do basic queries like listing all known unix variants; if that is hidden in the table names
then you'll have to issue DDL queries to do the work of SELECT queries, which just sounds wrong to me.
Yes this might be a problem but one I could easily overcome.
>I'd go for a tree, possibly using recursive CTE's to dig it.
I was thinking a window function but yea I am sure there is a way to do it with a flat table.