On 1/11/19 4:21 PM, Rich Shepard wrote:
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
We don't have more context in "activities.sql" but if your OP was
verbatim, it's keeling over on the comma ending the long text string.
Something syntactically askew I think.
