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

2 votes292 views3 answers
Sql interview query questions
SQL
5 votes296 views1 answer
Sql add column after another
SQL
18 votes277 views4 answers
Uninstall mysql on ubuntu
SQL
10 votes273 views4 answers
Join with multiple conditions sql
SQL
0 vote260 views1 answer
Trim sql oracle
SQL
0 vote257 views1 answer
Sql comparison operators
SQL
1 vote283 views1 answer
Backup mysql data only
SQL
2 votes282 views1 answer
Oracle convert run_duration to number
SQL
2 votes266 views5 answers
Alter table primary key postgresql
SQL
4 votes296 views1 answer
Alter session set nls_date_format
SQL