narusemotoki · March 12, 2018 08:48
diff --git a/fib.sql b/fib.sql
 WITH RECURSIVE fib (m, n) AS (
    SELECT 1, 1
    UNION ALL
    SELECT n, m + n FROM fib
 )
 SELECT m FROM fib
 LIMIT 10
 ;
 m  
 ----
  1
  1
  2
  3
  5
  8
 13
 21
 34
 55
 (10 rows)
	WITH RECURSIVE fib (m, n) AS (
	SELECT 1, 1
	UNION ALL
	SELECT n, m + n FROM fib
	)
	SELECT m FROM fib
	LIMIT 10
	;
	m
	----
	1
	1
	2
	3
	5
	8
	13
	21
	34
	55
	(10 rows)