SQLite Forum

Proposed JSON enhancements.
Login
I have used the `->` and `->>` operators in PG quite a bit, and find them extremely useful. However, the semantics is a bit different in PG: `->` returns a json (or jsonb) object, while `->>` returns text. Both require a json (or jsonb) object on the left, so errors due to malformed json can't happen. This difference could be confusing to some.