[SQL] Inheritance - Multiple membership

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

[SQL] Functions performed on intervals

ce you can give, Jimmie Fulton Systems Administrator Emory University School Of Medicine ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

RE: [SQL] Functions performed on intervals

Thanks for your response, > Actually, I can think of at least 3 different approaches. > What's "best" > depends on: > > 1) your control over the data structure (e.g. can you add an > "employee_history" table?) > 2) What changes to leave time calcualtions do you want to be > time-bound, > That

RE: [SQL] Database Design Question

with these thoughts on my own, and have not extensively tried the other way, so I'd be interested in hearing other's ideas for the other side. Thanks, Jimmie Fulton Systems Administrator Environmental Health & Safety Office Emory University School Of Medicine -Original Message

RE: [SQL] Database Design Question

even if a primary key already exists. Hope this makes sense/is helpful, Jimmie Fulton Systems Administrator Environmental Health & Safety Office Emory University School Of Medicine -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 4:22

[SQL] More Database Design Stuff

considered bad form? I have never needed to use them, but I happen to use auto-incrementing integer primary keys on all tables, as discussed earlier this week. Any thoughts on this subject is appreciated. Jimmie Fulton Systems Administrator Environmental Health & Safety Office Emory Univer