How to select a particular element from json array I have a 'notifications' table with a column 'dest_user_id_arr' as json with the following value:

id                     dest_user_id_arr
1                      {"users":[83,84,85]}
2                      {"users":[89,83,92]}
3                      {"users":[87,88,83]}


I would like to select those id where user is 83.
IF column is json:

 SELECT id 
  FROM notifications n
  WHERE json_array_elements(n.dest_user_id_arr-&gt;'users') = 83;


If column is jsonb: 

 SELECT id 
  FROM notifications n
  WHERE jsonb_array_elements(n.dest_user_id_arr-&gt;'users') = 83;