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
