JSON_expr {
object_member |
array_element |
wildcard |
name_or_index_list |
slice
} [...]
Syntax Elements
-
object_member
-
{.|..} name
-
array_element
-
[..] name [ { integer | * } ]
You must type the colored or bold brackets.
-
wildcard
-
{.|..} *
-
name_or_index_list
-
[..] [ list_value [,...] ]
-
slice
-
[..] [ integer : integer [: integer] ]
You must type the colored or bold brackets.
-
name
-
{ nonreserved_word | "string_literal" }
-
list_value
-
{ name | integer }
-
JSON_expr
- An expression that evaluates to a JSON data type.
- Object Member
- Consists of a descent operator followed by a Name syntax element.
- A descent operator is one of the following:
- A child operator '.'
- A recursive descent operator '..'
- Name
- A Teradata Vantage nonreserved word or a string literal enclosed in double quotation marks.
- Array Element
- Consists of an optional recursive descent operator '..' followed by an index value enclosed in brackets.
- An index value is one of the following:
- An unsigned INTEGER value
- A wildcard operator '*'
- Wildcard
- Consists of a descent operator followed by the wildcard character '*'.
- A descent operator is one of the following:
- A child operator '.'
- A recursive descent operator '..'
- The wildcard operator can be used both in reference to named and indexed items.
- Name or Index List
- Consists of an optional recursive descent operator '..' followed by two or more comma-separated list values enclosed in brackets.
- A list value is one of the following:
- A Name syntax element
- An unsigned INTEGER value
- Examples:
- Name list, such as [a,b,c]
- Index list, such as [0,3,5]
- Slice
- Consists of an optional recursive descent operator '..' followed by 2 or 3 colon-separated INTEGER values enclosed in brackets.
- For example, [0:5:3]