()
(,)
ARRAY[]
Arrays
Example: Empty arrays
Example: Single element array
(expr,)
ARRAY[expr]
Note
|
A trailing comma is required for the parser to recognize a single element expression as an array with parentheses, rather than a simple nested expression. |
Example: General array syntax
(expr, expr ... [,])
ARRAY[expr, ...]
If all of the elements in the array have the same type, the array will have a matching base type. If the element types differ the array base type will be object.
An array element reference takes the form of:
array_expr[index_expr]
index_expr
must resolve to an integer value.
This syntax is effectively the same as the array_get
system function and expects 1-based indexing.