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

From Rich Shepard
Subject Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]
Date
Msg-id alpine.LNX.2.20.1901021026370.20959@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On Wed, 2 Jan 2019, Ron wrote:

> Note that a CHECK constraint with 50 items is a *Very Bad Idea*, since
> changing such a constraint is very painful. Use a FK constraint instead.

Ron,

   It's even longer with Canadian provinces included. I gratefully accept
your advice and will use a table and foreign key instead.

Regards,

Rich



pgsql-general by date:

Previous
From: Kevin Brannen
Date:
Subject: RE: Relocatable Binaries (RPMs) : custom installation path forPostgreSQL
Next
From: Rich Shepard
Date:
Subject: Default for date field: today vs CURRENT_DATE