rivalitaet/fibonacci.sql

Last active April 28, 2016 11:11

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rivalitaet/4174bd286b45b51ec564d1a6cf5c759b.js"></script>
Save rivalitaet/4174bd286b45b51ec564d1a6cf5c759b to your computer and use it in GitHub Desktop.

Download ZIP

Creates fibonacci numbers directly in postgreSQL

Raw

fibonacci.sql

	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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment