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