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 vote122 views4 answers
Sql year
SQL
0 vote118 views1 answer
Check duplicate values plsql
SQL
3 votes124 views2 answers
Tsql join multiple record in one string
SQL
0 vote176 views1 answer
Run docker container with database as rds metabase
SQL
0 vote142 views1 answer
Oracle execute immediate quotes
SQL
6 votes157 views1 answer
How to get the size of the database in postgresql
SQL
0 vote138 views2 answers
Cascade syntax in sql
SQL
0 vote131 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote151 views1 answer
How to find unique element in sql
SQL
0 vote131 views1 answer
Postgress append string in select
SQL