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 CAKFQuwaMnzrnoeD9+ZGwS_Zepc91o4k0VMYkr_270bkQB-43Ow@mail.gmail.com
Whole thread Raw
In response to Re: insert into: NULL in date column  (Ricardo Martin Gomez <rimartingomez@hotmail.com>)
List pgsql-general
Tree view 
On Sat, Jan 12, 2019 at 10:08 AM Ricardo Martin Gomez
<rimartingomez@hotmail.com> wrote:
>
> Hi,
> In MYSQL Null date is equal '01/01/1900' or '01/01/1970', I don't remember but you can also use the same logic for
thecheck_constraint.
 
> Regards

Why?  PostgreSQL doesn't need hacks around this...

David J.

pgsql-general by date:

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