2 ms·
> SQL/JSON simplified accessor (T860–T864) Where is the doc for this one? I can find Postgres’ own JSON(B) operators, as well as jsonpath (sql/json path langua
by masklinn 4y ago
> SQL/JSON simplified accessor (T860–T864)
Where is the doc for this one? I can find Postgres’ own JSON(B) operators, as well as jsonpath (sql/json path language) support, but not SQL-level json paths, specifically the dot syntax.
- e12e 4y agoYeah, postgres uses proprietary syntax for this AFAIK. Would be nice to see t860-t864 supported. Then there's the whole graph data stuff that seems to come straight from Oracle? https://pgql-lang.org/ https://pgql-lang.org/