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 vote271 views1 answer
Mssql dockere
SQL
0 vote275 views1 answer
Offset in postgresql example
SQL
6 votes257 views1 answer
Postgresql add enum value
SQL
0 vote246 views1 answer
Data types mysql vs postgresql
SQL
0 vote258 views1 answer
Power bi find all ids not in other tables
SQL
5 votes253 views1 answer
Oracle find foreign key dependencies
SQL
8 votes361 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote264 views1 answer
Oracle cpu metric
SQL
41 votes328 views6 answers
Alter table add column in SQL Server
SQL
1 vote276 views1 answer
Group_concat max length mysql
SQL