Re: Implementing standard SQL's DOMAIN constraint - Mailing list pgsql-general

On Wed, 2 Jan 2019, David G. Johnston wrote:

> There is no magic name logic involved. A domain is just a type with
> inherent constraints that are user definable. You make use of it like any
> other type.
>
> Create table tbl (
> column_name state_code not null
> )
>
> Values stored in column_name are now of type state_code and constrained to
> be one of the check constraint values.

David,

   I'm not following you. I have two tables each with a column,
state_code char(2) NOT NULL.

   Do you mean that I need to write the column constraint for each table? If
not, I don't see from your response how to implement the multi-table
constraint for this column.

Regards,

Rich