json pl/v8 functions (not currently tested)

gistfile1.txt

CREATE or REPLACE FUNCTION
json_get(data json, prop text) RETURNS JSON as $$

  prop = prop.split('.');
  for (var i = 0, len = prop.length; i < len - 1; i++) {
    data = data[prop[i]];
  }

  return data[prop[len - 1]];
$$ LANGUAGE plv8 STABLE STRICT;

CREATE or REPLACE FUNCTION
json_set(data json, prop text, value json) RETURNS JSON as $$

  prop = prop.split('.');
  for (var i = 0, len = prop.length; i < len - 1; i++) {
    data = data[prop[i]];
  }

  data[prop[len - 1]] = value;
  
  return data;
$$ LANGUAGE plv8 STABLE STRICT;