- Notifications
You must be signed in to change notification settings - Fork49
Open
Description
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 byanimal_counts.tigers
and I would like that sort to use the index.
Metadata
Metadata
Assignees
Labels
No labels