Skip to main content

Module recursive_value

Module recursive_value 

Source
Expand description

RecursiveValue โ€” iterative expression evaluation for value-generating CTEs.

Implements WITH RECURSIVE cte(cols) AS (VALUES(init) UNION [ALL] SELECT step FROM cte WHERE condition) where no underlying collection is scanned. Column values are produced purely by expression evaluation on the previous row.

Functionsยง

execute_recursive_value
Iterative expression evaluation for value-generating recursive CTEs.