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:
{"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.
I see how I can use the jsquery
@@operator in aWHEREclause or in aCHECKconstraint. Is there an operator in either of the opclasses which would allow the use of the index in anORDER BYclause? 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.tigersand I would like that sort to use the index.