Skip to content

OBJECT_INSERT

OBJECT_INSERT(data, key, value[, update])

Takes a columns of JSON data, a column of string keys, and a columns of values and inserts the keys and values into the data. If the key is already present in the data, an error will be thrown, unless an additional argument (update) of type boolean is supplied, which will update existing keys to hold the new value only if the value is true.