postgresql random number code example
Example 1: postgresql random number
SELECT floor(random() * (h-l+1) + l)::int;
Example 2: postgresql random number
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;