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.
how to select the jsonb value for particular key using JSQuery? #33
Comments
|
I have the same question. Is it possible to use jsquery inside the select part or only in the where? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
is it possible to select the value for the key in json using JSQuery?
Something like this:
SELECT value @@ (.color) FROM js_test WHERE value @@ '.color = *'
Basically I am interested to see the value of color key in all the json documents if available. My key could be present in any level inside the json.
Thanks.