Re: insert into: NULL in date column

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: insert into: NULL in date column
Date: 2019-01-11 23:21:05
Message-ID: alpine.LNX.2.20.1901111518170.8922@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2019-01-11 23:24:56 Re: insert into: NULL in date column
Previous Message Rob Sargent 2019-01-11 23:05:51 Re: insert into: NULL in date column