vbilopav · September 23, 2020 11:02
diff --git a/random-sampling.sql b/random-sampling.sql
 select 
  g.code
 from (
    select generate_series as code from generate_series(1000, 9999) 
  ) g
  left outer join tbl t on g.code = t.id
 where 
  t.id is null
 order by
  random() limit 1;
	select
	g.code
	from (
	select generate_series as code from generate_series(1000, 9999)
	) g
	left outer join tbl t on g.code = t.id
	where
	t.id is null
	order by
	random() limit 1;