Postgresql JSON has key

Question

I'm trying to understand the way the Postgresql is dealing with JSON. I've declared a two-columns table and I'd like to create a new View to get some boolean values.

So far, I've been able to get the value as text but what I'd like to get is whether the field is defined or not. For example, if the JSON has the key frameMenuData.frameElement, it should print has_frame to true.

SELECT
  customer_data->>'frameMenuData'->>'frameElement' AS has_frame,
FROM
  simple_list
WHERE
  TRUE
  AND guid='AAAA';

The above code gives me the content of that row. I need to know if customer_data->>'frameMenuData'->>'frameElement' is defined or not.

How could I achieve that ?

Thanks for your help.

Manitoba · Accepted Answer · 2014-02-05 16:32:15Z

18

Problem solved. It was barely easy.

SELECT (customer_data->>'frameMenuData'->>'frameElement' IS NULL) AS has_frame,

answered Feb 5, 2014 at 16:32

Manitoba

8,73211 gold badges69 silver badges128 bronze badges

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

1 Comment

Marlen T. B. Over a year ago

I think you just want customer_data->>'frameMenuData' ? 'frameElement' AS has_frame see: postgresql.org/docs/current/functions-json.html and search for

Collectives™ on Stack Overflow

Postgresql JSON has key

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related