CONSTRAINT name With Domain As Check

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

  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