Re: Valid Input Syntax for Type DATE - Mailing list pgsql-general

On Wed, 29 Feb 2012, Andrew Gould wrote:

>>> If the column is null'able, I think you can use the keyword: DEFAULT
>>> insert into(id, xdate) values (1, DEFAULT);

>> Or... use NULL:
>> insert into(id, xdate) values (1, NULL);

> NULL works, but one advantage of using DEFAULT is that you won't have to
> worry which columns are set to NOT NULL.  This assumes that the NOT NULL
> columns have default values assigned to them, which is a good idea.

   Thank you both.

Rich