I have a problem I am trying to address and am looking to see if table
inheritance may be the solution.
My problem is this: I have a POS system using basic POS principles--i.e., I
have an invoice table, with a one-to-many related line items table. Now,
each line item may specify one of certain
Keary Suska wrote:
I have a problem I am trying to address and am looking to see if table
inheritance may be the solution.
My problem is this: I have a POS system using basic POS principles--i.e., I
have an invoice table, with a one-to-many related line items table. Now,
each line item may
On Wed, 2006-12-06 at 13:58 -0700, Keary Suska wrote:
My thoughts then turned to table inheritance, but I am not sure whether this
addresses the issue or introduce new problems. My thought was that I could
have an order_item table with the columns/data shared by all line items,
and then have
--- Jeff You can create a table called order_item with columns that exist for
all
items (the shared columns). Create a table called merchandise with
columns that exist only for merchandise and not other items (without any
of the shared columns).
When you insert new merchandise, put the