spence · January 29, 2019 08:18
diff --git a/print_1m_ints.sql b/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$;
	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$;