On Wed, Jun 13, 2012 at 10:35 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> On Tue, Jun 12, 2012 at 9:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> The code for this is as attached. Note that I'd rip out the normal-path
>>> tracking of line boundaries; it seems better to have a second scan of
>>> the data in the error case and save the cycles in non-error cases.
>
>> Really?!
>
> Um ... do you have a problem with that idea, and if so what? It would
> be considerably more complicated to do it without a second pass.
Could you explain how it's broken now, and why it will be hard to fix?People may well want to use a cast to JSON within
anexception block
as a way of testing whether strings are valid JSON. We should not
assume that the cost of an exception is totally irrelevant, because
this might be iterated.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company