Search Postgresql Archives

Re: insert into: NULL in date column

Subject: Re: insert into: NULL in date column
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Sat, 12 Jan 2019 05:38:58 -0800 (PST)
In-reply-to: <CAKFQuwY631=6t8vbeOUhqcSF0zcXcuTECvgJCO_FZ9eVBQMG_g@mail.gmail.com>
References: <alpine.LNX.2.20.1901111449480.8922@salmo.appl-ecosys.com> <410b055a-24a7-5e15-f4e6-462e64794530@gmail.com> <alpine.LNX.2.20.1901111518170.8922@salmo.appl-ecosys.com> <cc5fb963-ea67-0068-8158-04a190f16242@gmail.com> <CAD3a31Vh9y8QirWXU5TPD_XgaquMqXYfnK1PMOCOntyESp=yGw@mail.gmail.com> <alpine.LNX.2.20.1901111557460.8922@salmo.appl-ecosys.com> <CAKFQuwY631=6t8vbeOUhqcSF0zcXcuTECvgJCO_FZ9eVBQMG_g@mail.gmail.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

On Fri, 11 Jan 2019, David G. Johnston wrote:

VALUES (1, null, 3) is valid, VALUES (1,,3) is not.


David,

  Using null occurred to me when I saw that an empty space still failed.
Thanks for clarifying and confirming.

Best regards,

Rich

References:
- insert into: NULL in date column
  - From: Rich Shepard
- Re: insert into: NULL in date column
  - From: Rob Sargent
- Re: insert into: NULL in date column
  - From: Rich Shepard
- Re: insert into: NULL in date column
  - From: Rob Sargent
- Re: insert into: NULL in date column
  - From: Ken Tanzer
- Re: insert into: NULL in date column
  - From: Rich Shepard
- Re: insert into: NULL in date column
  - From: David G. Johnston