Re: one-to-one

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