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