How to remove element from postgres jsonb by key value?

Viewed 3381

I have a jsonb column with this format.

{
    "categoryList": [{
        "category_menu_id": "51",
        "is_featured_product": 0
    }, {
        "category_menu_id": "54",
        "is_featured_product": 1
    }]
}

How to remove category by category_menu_id?

This select query is working fine by category_menu_id.

select product_category 
from product  
where product_category->'categoryList' @> '[{"category_menu_id": "51"}]';
1 Answers
Related