Am 04.01.19 um 18:32 schrieb Rich Shepard:
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.
that's not a problem:test=*# create table projects(duration daterange default daterange(current_date,null) check(lower(duration) is not null));
CREATE TABLE Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
