SQLite Forum

Proposed JSON enhancements.
Login
Oh my error example for Postgres/SQLite is wrong, feeding NULL from json_nextract into json_extract should also return NULL. So in order for SQLite to behave similarly to Postgres for invalid inputs, you must use ->> all the way i.e.

```
->>'a'->>'b'->>'c' (not valid in postgres)
```

instead of 

```
->'a'->'b'->>'c'
```