SQLite Forum

Proposed JSON enhancements.
Login
> > errors due to malformed json can't happen
> 
> Here is a counter example that I just ran on PG 9.6 over at [sqlfiddle](https://sqlfiddle.com):
> 
> > ```
> > SELECT '{not valid json}'::json -> 'a';
> > ```

But here it is the typecast to json that throws the error, not the `->` operator. I.e.,

```
SELECT '{not valid json}'::json;
```

throws the same error (on PG 14 – for some reason, your sqlfiddle link doesn't open for me).

But I'm nitpicking. Personally, I have no problem with the somewhat different semantics anyhow. But I thought the issue worth mentioning, in case someone thinks it's a big deal.