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

On Fri, 4 Jan 2019, Rob Sargent wrote:

> Is the end_date always knowable at record insert?

Rob,

   Not always. Sometimes projects have known end dates, other times the end
is interminate until it happens.

> CHECK(end_date is null or start_date <= end_date)

   So a default of NULL should be applied, or just allowed to happen?

Thanks,

Rich