rivalitaet

WITH RECURSIVE fibs(val, tmp) as (
  SELECT 1::NUMERIC, 1::NUMERIC UNION ALL
  SELECT tmp, val + tmp FROM fibs
)
SELECT val FROM fibs limit 100

rivalitaet

WITH ps(v) as (
  WITH RECURSIVE t(v) as (
    SELECT 3::NUMERIC UNION ALL
    SELECT v+2 FROM t
  )
  SELECT v from t limit 1000
)
SELECT 2 UNION ALL
SELECT v as prime from ps as candidate
  WHERE NOT EXISTS (