Skip to content

Instantly share code, notes, and snippets.

@jrrojasg

jrrojasg/pg_random_int_array.sql

Forked from ekho/pg_random_int_array.sql
Created August 3, 2017 20:29
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jrrojasg/053963d84df551752db5c7841bdff49b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jrrojasg/053963d84df551752db5c7841bdff49b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Boris Gorbylev revised this gist Sep 20, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion pg_random_int_array.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@ CREATE OR REPLACE FUNCTION random_int_array(dim integer, min integer, max intege
    begin
    return (select array_agg(round(random() * (max - min)) + min) from generate_series (0, dim));
    end
    $BODY$ LANGUAGE plpgsql VOLATILE;
    $BODY$ LANGUAGE plpgsql;

    -- usage example
    select random_int_array(15, 6, 40);
  2. Boris Gorbylev renamed this gist Sep 20, 2013. 1 changed file with 0 additions and 0 deletions.
    0 pg_random_int_array → pg_random_int_array.sql
    View file
    File renamed without changes.
  3. Boris Gorbylev created this gist Sep 20, 2013.
    14 changes: 14 additions & 0 deletions pg_random_int_array
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    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 VOLATILE;

    -- 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}