Re: insert into: NULL in date column

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Sat, 12 Jan 2019 05:43:00 -0800 (PST)

On Sat, 12 Jan 2019, Ricardo Martin Gomez wrote:

Hi, one question.
Do you put explicit "NULL" in the column value?
Other option is.
You have to delete the column "next_contact" in your INSERT clause.
So, if the column has a default value, this value Will be inserted. Else
Null value will be inserted.

Ricardo,

  I thought of using an explicit null and David confirmed that to be the
solution. Also, he answered my question that having a default and check
constraint are not needed.

Thanks,

Rich