Skip to content

Instantly share code, notes, and snippets.

@spence

spence/print_1m_ints.sql

Created January 29, 2019 08:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save spence/5e7900323911278dd9786ec4404888bf to your computer and use it in GitHub Desktop.
Save spence/5e7900323911278dd9786ec4404888bf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
print_1m_ints.sql
DO
$do$
DECLARE
i INT;
BEGIN
FOR i IN 1..1000000 LOOP
SELECT LEFT(('x' || RIGHT(gen_random_bytes(3)::TEXT, 6))::BIT(24)::INT::TEXT, 4)::INT INTO i;
RAISE NOTICE '%', i;
END LOOP;
END
$do$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment