Search Postgresql Archives

Re: Comparing dates in DDL

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

Subject: Re: Comparing dates in DDL
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Fri, 4 Jan 2019 09:26:10 -0800 (PST)
In-reply-to: <f1c86c61-34c0-0741-6a6f-438a7fd5794a@gmail.com>
References: <alpine.LNX.2.20.1901040851090.29312@salmo.appl-ecosys.com> <CA+FnnTwVws6QCUAn4P6tHVkNCpddq9M7OOLN3B+27ZL80TCihg@mail.gmail.com> <f1c86c61-34c0-0741-6a6f-438a7fd5794a@gmail.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

On Fri, 4 Jan 2019, Rob Sargent wrote:

Is the end_date always knowable at record insert?


Rob,

  Not always. Sometimes projects have known end dates, other times the end
is interminate until it happens.

CHECK(end_date is null or start_date <= end_date)


  So a default of NULL should be applied, or just allowed to happen?

Thanks,

Rich

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

Follow-Ups:
- Re: Comparing dates in DDL
  - From: Rob Sargent

References:
- Comparing dates in DDL
  - From: Rich Shepard
- Re: Comparing dates in DDL
  - From: Igor Korot
- Re: Comparing dates in DDL
  - From: Rob Sargent

Prev by Date: Re: (Again) Column Store on PostGreSQL
Next by Date: Re: Comparing dates in DDL
Previous by thread: Re: Comparing dates in DDL
Next by thread: Re: Comparing dates in DDL
Index(es):
- Date
- Thread

[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