kungfuant/gist:e85e07f602c2247ef05a

Created February 11, 2015 13:32

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/kungfuant/e85e07f602c2247ef05a.js"></script>
Save kungfuant/e85e07f602c2247ef05a to your computer and use it in GitHub Desktop.

Download ZIP

Find missing games

Raw

gistfile1.sql

	SELECT vs.* FROM
	GENERATE_SERIES(1e6::bigint, (SELECT max(id) FROM games)) vs
	LEFT JOIN games ON vs = games.id
	WHERE games.id IS null;

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