[Postgres] Helper function to generate random integer in a range

pg_random_integer.sql

-- Helper function to generate random integer in a range.
-- Extremely useful for generating mock data for testing.
CREATE OR REPLACE FUNCTION RANDOM_BETWEEN(low INT ,high INT) 
   RETURNS INT AS
$$
BEGIN
   RETURN floor(random()* (high-low + 1) + low);
END;
$$ language 'plpgsql' STRICT;

-- Usage example.
SELECT RANDOM_BETWEEN(1, 1000);