Josh Berkus wrote:
> create table people (
> id SERIAL PRIMARY KEY
> name
> address ....
> );
> create table member_info (
> id INT REFERENCES people(id) PRIMARY KEY
> orientation
> officer ...
> );
> Using ID both as PK and as an FK in the member_info table creates a 1:0-1
> relationship.
What are the advantages and disadvantages of this approach over table
inheritance?
create table people (
id SERIAL PRIMARY KEY
name
address ....
);
create table members (
orientation
officer ...
) inherits people;
Adrian