On Sun, 29 Apr 2007, Tom Lane wrote:
Um, what are you trying to do that's different from declaring a column of
the table as being of type Permit_Type?
Tom,
Nothing. After further consideration I decided that the domain was
unnecessary and the table column with a CHECK() constraint the more
Rich Shepard <[EMAIL PROTECTED]> writes:
>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 do
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
