Examples: Unambiguous JSON Entity Reference

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 following shows unambiguous examples of JSON entity reference usage.

Example

SELECT jsonCol.name
FROM test.jsonTable
WHERE id=1;
Result:
jsonCol.name
------------
Cameron

Example

SELECT jsonCol.numbers[1]
FROM test.jsonTable
WHERE id=1;
Result:
jsonCol.numbers[1]
------------------
2

Example

SELECT new JSON('{"name" : "Cameron"}').name;
Result:
new JSON('{"name" : "Cameron"}').name
-------------------------------------
Cameron