Seamus Abshere writes:
>> foobar=# select coalesce('{}'::json->'a', 1);
>> ERROR: COALESCE types json and integer cannot be matched
Right ...
> but check it out when I use a string instead of an integer:
>> foobar=# select coalesce('{}'::json->'a', 'b');
>> ERROR: invalid input syntax for typ
seamusabshere wrote
> 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);
>>
