I define a table, Permits, that includes a column for type.
Permit_Type is a domain with permissible names:
CREATE DOMAIN Permit_Type
as TEXT
CHECK (value in ('Environmental', 'Health', 'Safety', 'Occupancy'));
Can I name that domain check within the Permits table as follows?
CREATE TABLE Permits (
...
type Permit_Type
CONSTRAINT invalid_permit_type
...
);
If not, does the constraint name belong in the domain definition?
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
