Hey, I currently evaluate the Json capabilities of SQLite. I copied some examples from the docs:

json_insert('[1,2,3,4]','$[#]',99)

but I only get

JSON path error near '[#]': SELECT json_insert('[1,2,3,4]','$[#]',99)

Are the docs not up to date? Am I doing something wrong with the path?

On another note, I don't know if this is the right place but the example

json_extract('{"a":2,"c":[4,5],"f":7}','$.c[#-1]'

is missing a parentheses at the end :).

Thanks and regards

The docs are up-to-date. I'm guessing it is your SQLite that is not. The $[#] path feature in the JSON functions was just added in the version 3.31.0. What version of SQLite are you testing with?