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;

Source: postgresqltutorial.com

Postgresql random number

SELECT floor(random() * (h-l+1) + l)::int;

Source: postgresqltutorial.com

Generate random data postgresql

insert into towns (
    code, article, name, department
)
select
    left(md5(i::text), 10),
    md5(random()::text),
    md5(random()::text),
    left(md5(random()::text), 4)
from generate_series(1, 1000000) s(i)

Source: stackoverflow.com

Similar codes

0 vote139 views1 answer
Oracle call a function in a insert statement
SQL
0 vote183 views2 answers
How to take recent row without limit in mysql
SQL
1 vote139 views1 answer
Postgres first_value in gropby
SQL
0 vote144 views1 answer
Oracle INTERVAL DAY to second to number
SQL
8 votes182 views3 answers
Postgres database sizes
SQL
0 vote145 views1 answer
Join in update query in mysql
SQL
5 votes126 views1 answer
Sql first day of current year
SQL
10 votes141 views4 answers
Primary key sql
SQL
9 votes147 views3 answers
Find all tables with column name
SQL
1 vote107 views2 answers
Delete auto increment mysql
SQL