フィボナッチSQL

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)