with_rec_all_empty.sql 145 B

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