Re: Problem with inheritance

Tom Lane wrote:

> Alfonso Peniche <alfonso(at)iteso(dot)mx> writes:
> > I have the following inheritance relation:
>
> > user
> > |
> > ----------
> > | |
> > student employee
>
> > If I insert John into table student, how can I insert him afterwards so
> > that he is also an employee (this could happen several days later)?
>
> If a student could also be an employee, then your table layout is
> fundamentally wrong.
>
> regards, tom lane

Sorry, in Informix (which I've been working on for sometime now) this is the
way I would handle the inheritance. What would be the right way of doing
this same thing with pgsql (considering that someone can be both a student
and an employee)?

Thanx for your help.