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

14 votes292 views2 answers
Oracle export trigger ddl
SQL
0 vote264 views1 answer
Vbscript create ADODB.Connection
SQL
4 votes286 views1 answer
Is there any command to change postgres password
SQL
0 vote285 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
3 votes274 views1 answer
Oracle user quota on tablespace
SQL
18 votes291 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote274 views1 answer
Mysql workbench primary key
SQL
-1 vote325 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote312 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote295 views1 answer
Mysql page segment
SQL