5 lines
241 B
Text
5 lines
241 B
Text
|
set variable base= { 'name': 'Rocket Skates', 'price': 12.75, 'color':'yellow'}::JSON;
|
||
|
|
set variable update = { 'price': 15.25, 'color': 'red', 'year': 1974 }::JSON;
|
||
|
|
|
||
|
|
select json_merge_patch(getvariable('base'),getvariable('update')) as add;
|