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 vote384 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote395 views1 answer
Mysql value ends with
SQL
11 votes375 views1 answer
Sql query to find duplicates in column
SQL
1 vote328 views2 answers
Into sql
SQL
0 vote367 views1 answer
Where date in datetime mysql
SQL
0 vote405 views1 answer
Traccar mysql
SQL
12 votes367 views1 answer
Docker mysql random root password
SQL
0 vote380 views1 answer
Database db connection string format
SQL
0 vote389 views1 answer
Mysql command line top 10
SQL
16 votes362 views4 answers
Sort by sql
SQL