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:
I see how I can use the jsquery
@@
operator in aWHERE
clause or in aCHECK
constraint. Is there an operator in either of the opclasses which would allow the use of the index in anORDER BY
clause? For example, suppose I have a table full of jsonb documents which look like:{"time":1430432587, "place":"zoo", "animal_counts":{"monkeys":77, "tigers":3, "elephants":9.4}}
I would like to sort by
animal_counts.tigers
and I would like that sort to use the index.The text was updated successfully, but these errors were encountered: