Search Postgresql Archives

Re: Comparing dates in DDL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux