Are you able to define table types within tables with Postgres? I know
some pure OO databases allow it, but, the manual isn't clear about whether
Postgres can.
For example, having a table "fruit" define a datatype of fruit for which
could then use as a datatype in table apples? I'm not really talking
about table inheritance which I know postgres does, more like true object
inheritance (creating an instance of fruit with specific characteristics
making it an apple).
Just curious.