Random Range

Snippets

Random Range

Works with PostgreSQL

Any version

Written in

SQL

Depends on

Nothing

by Scott Bailey 'Artacus'

CREATE OR REPLACE FUNCTION random(numeric, numeric)
RETURNS numeric AS
$$
   SELECT ($1 + ($2 - $1) * random())::numeric;
$$ LANGUAGE 'sql' VOLATILE;

Usage

SELECT random(1,10)::int, random(1,10);

 random     random           
 ---------  ---------------- 
 5          3.20581795740873