Unexpected syntax error when using JSON -> in 9.3.5
| От | Seamus Abshere |
|---|---|
| Тема | Unexpected syntax error when using JSON -> in 9.3.5 |
| Дата | |
| Msg-id | 5421961B.2060602@abshere.net обсуждение исходный текст |
| Ответы |
Re: Unexpected syntax error when using JSON -> in 9.3.5
Re: Unexpected syntax error when using JSON -> in 9.3.5 |
| Список | pgsql-general |
hi all,
This part looks correct and expected:
> $ psql foobar
> psql (9.3.5)
> Type "help" for help.
>
> foobar=# select coalesce('{}'::json->'a', 1);
> ERROR: COALESCE types json and integer cannot be matched
> LINE 1: select coalesce('{}'::json->'a', 1);
> ^
but check it out when I use a string instead of an integer:
> foobar=# select coalesce('{}'::json->'a', 'b');
> ERROR: invalid input syntax for type json
> LINE 1: select coalesce('{}'::json->'a', 'b');
> ^
> DETAIL: Token "b" is invalid.
> CONTEXT: JSON data, line 1: b
That seems like the wrong error - shouldn't it be the equiv of "[...]
json and string cannot be matched"?
Thanks,
Seamus
--
Seamus Abshere, SCEA
https://github.com/seamusabshere
В списке pgsql-general по дате отправления: