Re: Problem with inheritance

Tom Lane wrote:

> Alfonso Peniche <alfonso@iteso.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.