Re: slightly confusing JSON error context - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: slightly confusing JSON error context
Date
Msg-id 51C26A89.9010303@dunslane.net
Whole thread Raw
In response to slightly confusing JSON error context  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On 06/19/2013 09:19 PM, Peter Eisentraut wrote:
> These are some cases from the regression tests:
>
> SELECT ''::json;                -- ERROR, no value
> ERROR:  invalid input syntax for type json
> LINE 1: SELECT ''::json;
>                 ^
> DETAIL:  The input string ended unexpectedly.
> CONTEXT:  JSON data, line 1:
>
> SELECT '    '::json;            -- ERROR, no value
> ERROR:  invalid input syntax for type json
> LINE 1: SELECT '    '::json;
>                 ^
> DETAIL:  The input string ended unexpectedly.
> CONTEXT:  JSON data, line 1:
>
> Perhaps we should either put some quotes around the whitespace at the
> end of the CONTEXT lines, or write something like "end of input".
> Otherwise this might look weird.  There might be more complicated cases
> where it looks even weirder.
>

It's been that way since 9.2. I at least have no problem if you want to 
make improvements.

cheers

andrew



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks)
Next
From: Satoshi Nagayasu
Date:
Subject: Re: Fix pgstattuple/pgstatindex to use regclass-type as the argument