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 vote356 views2 answers
Truncate table sqlite
SQL
1 vote316 views1 answer
How to use a trigger to validate input data
SQL
1 vote311 views1 answer
Mysql best tutorial for beginners
SQL
3 votes330 views1 answer
Oracle APEX elapsed time
SQL
0 vote298 views6 answers
Unique key in sql
SQL
11 votes306 views4 answers
Round in sql
SQL
2 votes299 views1 answer
Get first 3 letters name in sql
SQL
4 votes303 views1 answer
Create column mysql terminal
SQL
12 votes298 views3 answers
Duplicate a column in sql
SQL
0 vote326 views2 answers
Advantages of stored procedures sql
SQL