Am 04.01.19 um 17:53 schrieb Rich Shepard:
> I have a projects table that includes these two columns:
>
> start_date date DEFAULT CURRENT_DATE,
> end_date date
> CONSTRAINT valid_start_date
> CHECK (start_date <= end_date),
>
> 1. Do I need a DEFAULT value for the end_date?
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.
> 2. If so, please suggest a value for it.
other solution for such 2 fields: you can use DATERANGE, only one field.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com