Inheritance - Multiple membership - Mailing list pgsql-sql

From Jimmie Fulton
Subject Inheritance - Multiple membership
Date
Msg-id FB93404FB67ED311ABF9009027991188417E66@www.ehso.emory.edu
Whole thread Raw
Responses Re: Inheritance - Multiple membership
List pgsql-sql
This question was asked in 1998 on this list by someone else, but did not
appear to be answered...

Say I have a tbl_person.  tbl_teacher and tbl_student both inherit from
tbl_person and each have their own extended attributes.  Is it possible for
a person in tbl_person to be both a teacher at the school, and also a
student (say night school or something).  Also, the student may be a
part-time employee, like a graduate student.  If it is possible, what would
an insert look like.  Given the possibility that someone can exist in both
tbl_teacher and tbl_student, what happens if you delete their student
record.  I'm guessing that it should leave the other records in tact.

Any ideas?



pgsql-sql by date:

Previous
From: Martín Marqués
Date:
Subject: Re: [GENERAL] tables, permissions, sequences
Next
From: Christophe Labouisse
Date:
Subject: Re: Integrity reference and inheritance