Postgres Pro
Downloads
Home   >   mailing lists

Re: insert into: NULL in date column - Mailing list pgsql-general

From David G. Johnston
Subject Re: insert into: NULL in date column
Date
Msg-id CAKFQuwa+6BXacKks+p9AM9ka4H3iOvW6Z=g=hz_+LphzY_0=Tg@mail.gmail.com
Whole thread Raw
In response to insert into: NULL in date column  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: insert into: NULL in date column
List pgsql-general
Tree view 
On Fri, Jan 11, 2019 at 3:56 PM Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> A table has this column definition:
>
> next_contact date DEFAULT '2020-11-06'
>                 CONSTRAINT valid_next_date
>                 CHECK (next_contact >= CURRENT_DATE),
>
> (and I don't know that it needs a default).

The default does seem a bit arbitrary and pointless...

David J.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: insert into: NULL in date column
Next
From: "David G. Johnston"
Date:
Subject: Re: insert into: NULL in date column