Skip site navigation (1) Skip section navigation (2)

mutually exclusive subtypes

From: "Olinga K(dot) Abbott" <olingaa(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: mutually exclusive subtypes
Date: 2006-04-13 15:08:37
Message-ID: 20060413150837.70279.qmail@web31802.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Let's say I have the following contrived schema:

TRANSPORTATION_MODE
mode_ID serial
model_number text

AIRPLANE
mode_ID int FK
operational_ceiling nt

AUTOMOBILE
mode_ID int FK
cruising range int


Of course, being an airplane and being an automobile are mutually exclusive.
How does one program the mutual exclusivity in PostgreSQL? I've studied using
check contraints, triggers, and rules, but I'm not finding any obvious way to
program this.

Responses

pgsql-novice by date

Next:From: Daniel T. StaalDate: 2006-04-13 15:23:28
Subject: Re: mutually exclusive subtypes
Previous:From: Bruce MomjianDate: 2006-04-13 13:13:06
Subject: Re: PostgreSQL a slow DB?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group