RECURSE(...)

All functions > ARRAY OF ROWS > RECURSE(...)

Produces an array of rows by iterating a seed ROW, optionally traversing entity relationships

Syntax

ROW(...).RECURSE(
  [ WITH local_binding := expr, ... ]
  SELECT field_definitions
  [ WHILE condition ]
  [ VIA field BIND TO feature FOLLOW feature ]
  MAX_LEVEL n
)

ROW(...).RECURSE(
  [ WITH local_binding := expr, ... ]
  SELECT field_definitions
  [ WHILE condition ]
  [ VIA field BIND TO feature FOLLOW feature ]
  MAX_LEVEL n
)

Availability

Available on DuckDB. Not available on Trino, Serving.

Related Functions

• RECURSE()

Examples

Count until n reaches 5

DEFINE
    seed_n := INPUT(BIGINT)
RETURN
    seed_n,
    result := ROW(seed_n AS n).RECURSE(
        RETURN n := prev[n] + 1
        WHILE n < 5
        MAX_LEVEL 10
    )
FOR
    seed_n := BIND_VALUES(ARRAY(1, 10))
;