3 ms·
The extremely limited "indexing" described by this MySQL documentation is absolutely supported by PostgreSQL's JSON type, and in fact has been for years now if
by saurik 11y ago
The extremely limited "indexing" described by this MySQL documentation is absolutely supported by PostgreSQL's JSON type, and in fact has been for years now if you were willing to tolerate writing a couple lines of plv8 stored procedure. However, if you want the "actual indexing" (on arbitrary content, not just specific keys or lookup strategies) that PostgreSQL provides for JSONB on JSON columns, if you do a functional GiST index on a JSON column cast to a JSONB, you should find that PostgreSQL stores only the JSON but yet can index it "as if" it were JSONB. So, no: absolutely no benefit here.