News for hackers. Stuff that matters.

A comment on Better JSON in Postgres with PostgreSQL 14. Parent comment

Re:Better JSON in Postgres with PostgreSQL 14 by bhaney on Tuesday June 01, 2021 @04:06PM (#27360555)
GIN indices in general support the @> operator but not the = operator, unrelated to JSON.

You can create a regular btree index on a particular json path and get an index usable for = operations on that path.

[ Parent | on HN ]

There are no comments on this comment yet.