row()

Create an unnamed STRUCT (tuple) containing the argument values.

Arguments & returns

row(…)

Scalar
Overload link … Varargs Returns
#01 ANY STRUCT

… accepts a variable number of arguments of the type shown.

Example

row example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

In other engines

BigQuerycast()

CAST(STRUCT<a INT64>(1) AS STRUCT<a INT64>)
In Haybarn
CAST(CAST(ROW(1) AS STRUCT(a BIGINT)) AS STRUCT(a BIGINT))

SQLGlot example ↗