Re: slightly confusing JSON error context

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