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.