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