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 vote197 views1 answer
How to select even id in sql
SQL
0 vote255 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
6 votes255 views2 answers
Oracle undotbs usage
SQL
0 vote225 views1 answer
Stored procedure function relation
SQL
22 votes201 views4 answers
Show list of users in mysql
SQL
0 vote180 views1 answer
Mysql create table columns with spaces
SQL
3 votes232 views3 answers
Create table in SQL Server
SQL
1 vote209 views1 answer
Postgres set column based on another column
SQL
1 vote225 views1 answer
Mysql count all table rows
SQL
1 vote197 views1 answer
Postgres check blocking
SQL