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 vote173 views1 answer
What does the -p flag do in mysql cli
SQL
15 votes178 views4 answers
Pl sql
SQL
0 vote181 views1 answer
Select in select sql
SQL
2 votes197 views2 answers
Sql lag
SQL
0 vote180 views1 answer
Update top 100 order by sql server
SQL
0 vote163 views1 answer
Sql examples from your work
SQL
0 vote182 views1 answer
Modificar tipo de dato sql server
SQL
12 votes218 views4 answers
How to drop all tables in postgresql
SQL
0 vote201 views1 answer
Drop view in mysql
SQL
0 vote178 views1 answer
Sql include rows with 0 values
SQL