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

On Fri, 4 Jan 2019, Andreas Kretschmer wrote:

> no, you can use NULL, for instance. You don't need an explicit value.
> But maybe you want to set the start_date to NOT NULL.

Andreas,

   Yes, I added NOT NULL to the start_date column.

>> 2. If so, please suggest a value for it.
>
> other solution for such 2 fields: you can use DATERANGE, only one field.

   Only if all projects have a known end_date; some don't.

Thanks,

Rich