Home > mailing lists

Re: Comparing dates in DDL - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Comparing dates in DDL
Date	January 4, 2019 20:24:12
Msg-id	CAKFQuwaQn2n7a2pR2+7UvvwNY-VneOpWNwW+sqwmxEwsW++YWA@mail.gmail.com Whole thread Raw
In response to	Re: Comparing dates in DDL (Rob Sargent <robjsargent@gmail.com>)
Responses	Re: Comparing dates in DDL (Rich Shepard <rshepard@appl-ecosys.com>)
List	pgsql-general

On Friday, January 4, 2019, Rob Sargent <robjsargent@gmail.com> 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.

From: Rich Shepard
Date: 04 January 2019, 20:21:52
Subject: Re: Comparing dates in DDL

From: legrand legrand
Date: 04 January 2019, 20:25:17
Subject: Re: (Again) Column Store on PostGreSQL