Database · Medium
Query, filter, and aggregate a JSONB column.
DatabaseSQL QueriesSeniorJSON
Answer preview
In jsonb, -> returns JSON and ->> returns text; containment @> is the operator you filter with because it is the one a GIN index can accelerate.…