Reading JSON text and outputting a Boolean depending on numeric value

Question

Here is a little snippet of my json text which is in a column in a database. I want to write a query that will return a Boolean value if the values for "1", "2", etc. = 0. So if "1": 0 I want to have a false value so then I can write a conditional statement to display a message depending of the Boolean value.

 {
     "ENABLE": [
        {
            "1": 1,
            "2": 1,
            "3": 1,
            "4": 1
       }
   ]
    }

you need to tag your dbms

eshirvana
– eshirvana

2021-07-28 19:04:49 +00:00
Commented Jul 28, 2021 at 19:04 — eshirvana
– eshirvana, Commented Jul 28, 2021 at 19:04
gotcha just updated @eshirvana

Tom Hagerty
– Tom Hagerty

2021-07-28 19:14:29 +00:00
Commented Jul 28, 2021 at 19:14 — Tom Hagerty
– Tom Hagerty, Commented Jul 28, 2021 at 19:14

eshirvana · Accepted Answer · 2021-07-28 19:57:49Z

1

here is one way using jsonb functions:

select jsonb_array_elements((jsonb_extract_path(jsoncolumn::jsonb,'ENABLE'))) @> '{"4":1}'::jsonb as checking
from test

'{"4":1}' can be parameterized, as if you make a procedure , or if you build your query as dynamic sql.

db<>fiddle here

edited Jul 28, 2021 at 19:57

answered Jul 28, 2021 at 19:52

eshirvana

24.7k3 gold badges28 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading JSON text and outputting a Boolean depending on numeric value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related