Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: insert into: NULL in date column
Date
Msg-id alpine.LNX.2.20.1901120800140.10285@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: insert into: NULL in date column  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: insert into: NULL in date column  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
On Sat, 12 Jan 2019, David G. Johnston wrote:

> Actually, you didn't ask about the check constraint, which is actually
> horribly broken since current_date is not an immutable function.

David,

   I know that nulls cannot be validly used in comparisons which makes the
check constraint FUBAR.

Thanks,

Rich

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