Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. UPDATE public.mytable SET
  2. jsonfieldname = jsonb_set( jsonfieldname, '{json_obj_key}', array_to_json(
  3. ARRAY(
  4. SELECT DISTINCT( UNNEST( ARRAY(
  5. SELECT json_array_elements_text( COALESCE( jsonfieldname::json->'json_obj_key', '[]' ) )
  6. ) || ARRAY['Element to add'] ) )
  7. )
  8. )::jsonb )
  9. WHERE id = 23
  10. RETURNING *;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement