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 vote127 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote165 views1 answer
SQL server query column yes or no
SQL
1 vote143 views3 answers
How to create a table structure from another table in mysql
SQL
6 votes123 views2 answers
Mysql 1 day ago
SQL
0 vote116 views1 answer
Mssql now diff 90 day
SQL
0 vote128 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote118 views2 answers
Mysql: command not found
SQL
0 vote107 views1 answer
Mysql:5.6 syntax create table
SQL
5 votes121 views2 answers
Mysql import gzip db
SQL
0 vote122 views1 answer
Mysql workbench download for iinux mint 19.3
SQL