15.10 - Examples: Unambiguous JSON Entity Reference - 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 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