Example: Result Is Implicitly a JSON ARRAY

Teradata Vantageā„¢ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
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"}]