> SQL/JSON simplified accessor (T860–T864) Where is the doc for this one? I can ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		masklinn on April 14, 2023 \| parent \| context \| favorite \| on: SQL:2023 is finished: Here is what's new > 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 on April 14, 2023 [–]

Yeah, 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/

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact