Re: Comparing dates in DDL

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Comparing dates in DDL
Date: 2019-01-04 17:30:05
Message-ID: alpine.LNX.2.20.1901040927060.29312@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-01-04 17:32:09 Re: Comparing dates in DDL
Previous Message Rich Shepard 2019-01-04 17:26:10 Re: Comparing dates in DDL