On Fri, 4 Jan 2019, Andreas Kretschmer wrote:
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));
Andreas, Thank you. That's a data type I've not before used. Regards, Rich
