Postgres Pro
Downloads
Home   >   mailing lists

Re: Blank, nullable date column rejected by psql - Mailing list pgsql-general

From Rich Shepard
Subject Re: Blank, nullable date column rejected by psql
Date
Msg-id alpine.LNX.2.20.1902111531040.28800@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Blank, nullable date column rejected by psql  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Blank, nullable date column rejected by psql  (Rich Shepard <rshepard@appl-ecosys.com>)
Re: Blank, nullable date column rejected by psql  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-general
Tree view 
On Mon, 11 Feb 2019, Ron wrote:

> NULL is nothing. Blank isn't nothing; blank is a zero-length string. 
> Thus, you need to tell Pg "nothing", not "blank string".

Ron,

All of you who responded drove home my need to explicitly enter null when
there are no data for a column.

Thanks,

Rich

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Blank, nullable date column rejected by psql
Next
From: Ron
Date:
Subject: Re: Blank, nullable date column rejected by psql