with_rec_all.sql 118 B

12345678
  1. --!syntax_pg
  2. WITH RECURSIVE t(n) AS (
  3. SELECT 1
  4. UNION ALL
  5. SELECT n+1 FROM t WHERE n < 5
  6. )
  7. SELECT * FROM t