jerryji wrote:
> As a simplified example, the schema products(productid INTEGER, price
> REAL, for_region GEOM, warranty_till DATE, package_byte INTEGER) is
> not efficient for a company that produces both cars and software
> because cars won't need package_byte column while software won't need
> for_region column. In a real life case, the superset could have tens
>
> Is it possible to design an effective schema for this?

Inheritance?

--

regards, jr. (jr@tailorware.org.uk)