Re: insert into: NULL in date column

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

On Fri, 11 Jan 2019, Rob Sargent wrote:

> > psql:activities.sql:2: ERROR:  invalid input syntax for type date: ""
> > LINE 2: ...reaction they''ve experienced environmental issues.','','');
                                                                 ^
> Miss-matched single quotes in activities.sql?

Rob,

  I don't see the mis-match. The preceeding text column escapes the internal
single quotes by doubling them while the entire string is single quoted.

Regards,

Rich