Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign upGitHub is where the world builds software
Millions of developers and companies build, ship, and maintain their software on GitHub — the largest and most advanced development platform in the world.
Question: jsquery in order by #10
Open
Comments
|
Unfortunately, that's not possible to this in GIN indexes yet. You could create btree expression index on js->'animal_counts'->'tigers'. |
|
What is the status of VODKA indices making it into Postgres master? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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.