Skip to content

Recursive queries

There are no real recursive querys!

WITH RECURSIVE t(n) AS (
VALUES (1)
UNION ALL
SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t;

Link to Documentation