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.1901111518170.8922@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: insert into: NULL in date column  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: insert into: NULL in date column  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: insert into: NULL in date column
Next
From: Rob Sargent
Date:
Subject: Re: insert into: NULL in date column