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

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty
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"}]