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]