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

2019-01-02 Thread Rich Shepard
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 for

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

2019-01-02 Thread Ron
On 1/2/19 12:05 PM, Rich Shepard wrote: On Wed, 2 Jan 2019, David G. Johnston wrote: You add the create domain command once before any objects that make use of it. David,   This is the answer I sought: postgres supports the create domain command. I did not see this in your first response.

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

2019-01-02 Thread Rich Shepard
On Wed, 2 Jan 2019, David G. Johnston wrote: You add the create domain command once before any objects that make use of it. David, This is the answer I sought: postgres supports the create domain command. I did not see this in your first response. Thanks very much, Rich