3 ms·
> This is using the new -> JSON operator which was added to SQLite a few months ago. Is this available in Postgresql? Or what would be the equivalent?
by nextaccountic 4y ago
> This is using the new -> JSON operator which was added to SQLite a few months ago.
Is this available in Postgresql? Or what would be the equivalent?
- dragonwriter 4y agoPostgres has similar JSON access operators, but slightly different syntax: https://www.postgresql.org/docs/current/functions-json.html https://www.postgresql.org/docs/current/functions-json.html
- simonw 4y agoI believe the SQLite operators were directly inspired by PostgreSQL and MySQL. There's a detailed comparison here: https://sqlite.org/src/doc/json-enhancements/doc/json-enhancements.md https://sqlite.org/src/doc/json-enhancements/doc/json-enhanc...
- SPBS 4y agoI believe this https://sqlite.org/src/doc/json-in-core/doc/json-enhancements.md https://sqlite.org/src/doc/json-in-core/doc/json-enhancement... is more up to date, as json_nextract is no longer in the core functions.