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 (opens new window)
← Window Functions Programming with PL/pgSQL →