- 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