Arrays

Example: Empty arrays
()
(,)
ARRAY[]
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.

results matching ""

    No results matching ""