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 vote138 views2 answers
Sql regex vowel
SQL
0 vote135 views1 answer
Prodection ready postgres database step by step
SQL
0 vote132 views1 answer
Mysql Digital Ocean connection problems
SQL
2 votes130 views1 answer
Sql server conection string
SQL
16 votes121 views1 answer
Sqlserver add column to table
SQL
0 vote117 views1 answer
What is initial catalog in sql connection string
SQL
6 votes136 views2 answers
Postgresql restore from dump
SQL
0 vote127 views1 answer
Select a row include list of array with join table SQL
SQL
6 votes125 views5 answers
Mysql get last insert id
SQL
0 vote126 views1 answer
Sql server udf performance
SQL