Skip to content

Instantly share code, notes, and snippets.

@jrrojasg
Forked from ekho/pg_random_int_array.sql
Created August 3, 2017 20:29
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 jrrojasg/053963d84df551752db5c7841bdff49b to your computer and use it in GitHub Desktop.
Save jrrojasg/053963d84df551752db5c7841bdff49b to your computer and use it in GitHub Desktop.
Postgresql function for generating random integer array
CREATE OR REPLACE FUNCTION random_int_array(dim integer, min integer, max integer) RETURNS integer[] AS $BODY$
begin
return (select array_agg(round(random() * (max - min)) + min) from generate_series (0, dim));
end
$BODY$ LANGUAGE plpgsql;
-- usage example
select random_int_array(15, 6, 40);
-- return example
-- | random_int_array
-- | integer[]
-- -----------------------------------------------------
-- 1 | {26,20,13,37,21,25,38,39,36,21,31,6,32,16,22,10}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment