Random DOUBLE PRECISION between

Question

How can I get a random number between two DOUBLE PRECISION number?

The following generate number outside of range

CREATE OR REPLACE FUNCTION random_between(low DOUBLE PRECISION, high DOUBLE PRECISION)
    RETURNS DOUBLE PRECISION AS
$$
BEGIN
    RETURN random() * (high - low + 1) + low;
END;
$$ language 'plpgsql' STRICT;

Answer 1

demo:db<>fiddle

Remove the + 1 from the range.