Re: Comparing dates in DDL

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Comparing dates in DDL
Дата
Msg-id CAKFQuwbBQzEhUqQHm0zYPJ3aXbRYWO3pb=2k9_qM_O_C8EajkA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Comparing dates in DDL  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Comparing dates in DDL  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
On Friday, January 4, 2019, Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Fri, 4 Jan 2019, David G. Johnston wrote:

The is null expression is redundant since check constraints pass when the
result is unknown.

David,

  I wondered about this since NULL can be missing, unknown, or otherwise
defined. Are there benefits to allowing an empty value in that column when
checking that it's later than the start date rather than explicitly setting
a default date after the start date?


I don’t understand the question...

David J. 

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

Предыдущее
От: Mark Jeffcoat
Дата:
Сообщение: Re: Showing table comments with psql
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: (Again) Column Store on PostGreSQL