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

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]
Дата
Msg-id 284b6b1d-3a8f-f0a6-8446-eaf48174a565@gmail.com
обсуждение исходный текст
Ответ на Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
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.

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.

--
Angular momentum makes the world go 'round.

В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2