Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]
Date: 2019-01-02 18:28:29
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-01-02 21:49:21 Default for date field: today vs CURRENT_DATE
Previous Message Kevin Brannen 2019-01-02 18:25:26 RE: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL