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

1 vote232 views1 answer
Mysql pretty date format
SQL
0 vote254 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote242 views1 answer
Postgres create extension if not exists
SQL
2 votes235 views1 answer
Postgresql drop primary key constraint
SQL
12 votes243 views4 answers
Mysql get date difference in hours
SQL
0 vote238 views1 answer
Order by in codeigniter query builder
SQL
0 vote246 views1 answer
How to get data from 2 database
SQL
3 votes242 views1 answer
Sql multi column index performance
SQL
0 vote257 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote256 views1 answer
What logs are available on RDS MySQL?
SQL