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 vote157 views1 answer
Delete mysql ubuntu 20.04
SQL
36 votes110 views6 answers
Delete from where sql
SQL
0 vote102 views1 answer
Run mssql server terminal
SQL
0 vote116 views1 answer
Sqlserver now
SQL
13 votes149 views6 answers
Mysql remove duplicates
SQL
0 vote103 views1 answer
Postgresql add not null and not empty constraint
SQL
2 votes137 views1 answer
Search query in mysql
SQL
0 vote110 views1 answer
Postgres row expiration
SQL
0 vote124 views1 answer
For row in sql database python loop
SQL
0 vote117 views1 answer
How to find total working hour in sql
SQL