Re: [GENERAL] Question on "best practise" for SELECTS on inherited tables

2009-12-08 Thread Merlin Moncure
On Tue, Dec 8, 2009 at 10:30 AM, Hubertus Freiherr von F?uerstenberg wrote: > > please consider the following exemplary setup: > > I want to store information on people in a database. People can be either > internal (staff) or external (company contacts, etc.). The idea was to use > one table for

[GENERAL] Question on "best practise" for SELECTS on inherited tables

2009-12-08 Thread Hubertus Freiherr von F?uerstenberg
Hello, please consider the following exemplary setup: I want to store information on people in a database. People can be either internal (staff) or external (company contacts, etc.). The idea was to use one table for all people and have the tables that store specific information inherit from