Skip to content

how to select the jsonb value for particular key using JSQuery? #33

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Open
bibekdw opened this issue Oct 17, 2018 · 2 comments
Open

how to select the jsonb value for particular key using JSQuery? #33

bibekdw opened this issue Oct 17, 2018 · 2 comments

Comments

@bibekdw
Copy link

bibekdw commented Oct 17, 2018

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.

@abonec
Copy link

abonec commented Nov 16, 2018

I have the same question. Is it possible to use jsquery inside the select part or only in the where?

@sokolcati
Copy link
Contributor

  1. I have doubts about your pseudocode example. The @@ operator returns true/false, so it's not clear to me what and how you want to achieve.
  2. Yes, the jsquery functionality can be freely used in the SELECT expression. Example from tests:
select 'asd(zzz < 13)'::jsquery;
     jsquery      
------------------
 "asd"."zzz" < 13
(1 row)``

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants