15.10 - Example: Result Is Implicitly a JSON ARRAY - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K
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"}]