tuple([value: storable]+) -> tuple

Carries a positional, fixed-arity sequence of compile-time-constant scalar values to the values input-table function. tuple(v1, v2, ...) does not produce a value on its own — its arguments are bundled and consumed by values to populate one row of the literal table.

Each argument must be a compile-time constant of type bool, string, int64, or float64. Typed nulls (for example int64_null()) are allowed. The number of arguments to tuple(...) must match the number of column names declared by the enclosing values(...) call, and values within a column must share a single type.

tuple(...) has no semantics outside of values(...); using it elsewhere is a compile-time error.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Misc

Examples

@t <- values("id", "name", tuple(1, "ada"), tuple(2, "alan"), tuple(3, "grace"))

Each tuple(...) supplies one row of literal cell values for the enclosing values(...) input-table function. The number of arguments to tuple(...) must equal the number of column names supplied to values, and values within a column must share a single type.