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
: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date
: Fri, 4 Jan 2019 10:24:12 -0700
Cc
: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
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
>
On Friday, January 4, 2019, Rob Sargent <
robjsargent@xxxxxxxxx
> wrote:
CHECK(end_date is null or start_date <= end_date)
The is null _expression_ is redundant since check constraints pass when the result is unknown.
David J.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Comparing dates in DDL
From:
Rich Shepard
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: Comparing dates in DDL
Next by Date:
Re: (Again) Column Store on PostGreSQL
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]
