Thread: slightly confusing JSON error context

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.

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