The example shows a JSON array combined with a JSON object; the result type is not specified.
The example uses the table(s) created earlier.
/* Result is implicitly a JSON ARRAY */ SELECT edata.Combine(edata2) FROM my_table WHERE eno=3;
Result: The result of combining a JSON array with a JSON object is implicitly a JSON ARRAY.
edata.Combine(edata2)
---------------------
[1,2,3, {"name" : "Lewis"}]