You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I see how I can use the jsquery @@ operator in a WHERE clause or in a CHECK constraint. Is there an operator in either of the opclasses which would allow the use of the index in an ORDER BY clause? For example, suppose I have a table full of jsonb documents which look like:
Activity
akorotkov commentedon Jun 15, 2015
Unfortunately, that's not possible to this in GIN indexes yet. You could create btree expression index on js->'animal_counts'->'tigers'.
EliSnow commentedon Aug 10, 2015
What is the status of VODKA indices making it into Postgres master?