undefined | Better HN

0 pointsNewJazz8mo ago0 comments

Postgresql supports jsonpath, right?

0 comments

3 comments · 1 top-level

Groxx8mo ago· 2 in thread

SQLite might too, though I'm struggling to find anything explicit about the syntax: https://sqlite.org/json1.html#jptr

it might just be a very limited subset?

NewJazzOP8mo ago

Looks like "JSON Pointer": datatracker.ietf.org/doc/html/rfc6901

thayne8mo ago

JSON pointer uses very different syntax. Sqlite looks like it uses something that is very similar to, but not quite compatible with, JSONPath.

j / k navigate · click thread line to collapse