Re: BUG #9168: Invalid JSON output generated by SQL statement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: garyjob(at)krake(dot)io
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9168: Invalid JSON output generated by SQL statement
Date: 2014-02-10 16:44:06
Message-ID: 12718.1392050646@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

garyjob(at)krake(dot)io writes:
> The invalid JSON output
> [{
> "drug bank":"cache \\"that stuff",
> "pingedAt":"2014-02-09 16:10:28-08"
> },{
> "drug bank":"cache \\"that stuff",
> "pingedAt":"2014-02-10 00:10:28-08"
> }]

> The final JSON output is not valid.

Hmm, I can't claim to have memorized the JSON spec, but that looks
generally sane to me. What do you think is invalid about it, exactly?

(If you're complaining about the backslash having been doubled, that's
an effect of the COPY, not a bug in the JSON output function.)

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message RogerBerkelmans 2014-02-11 02:27:19 BUG #9182: Data type (text) issue with MS SQL 2012
Previous Message Jeff Janes 2014-02-10 16:16:02 Re: BUG #9142: Bug installing "Database Cluster Initialisation Failed"