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.1901120541250.10285@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: insert into: NULL in date column  (Ricardo Martin Gomez <rimartingomez@hotmail.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, 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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: insert into: NULL in date column
Next
From: Tom Lane
Date:
Subject: Re: CREATE COLLATION to match pg_collation data