Re: Comparing dates in DDL - Mailing list pgsql-general

From Rich Shepard
Subject Re: Comparing dates in DDL
Date
Msg-id alpine.LNX.2.20.1901040934000.29312@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Comparing dates in DDL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Comparing dates in DDL
List pgsql-general
On Fri, 4 Jan 2019, David G. Johnston wrote:

>>   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,

   Understandable. :-)

   Perhaps this is more clear: is there a difference between not specifying a
default end_date value and specifying NULL as the default end_date value?

Regards,

Rich


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: (Again) Column Store on PostGreSQL
Next
From: "David G. Johnston"
Date:
Subject: Re: Comparing dates in DDL