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 vote216 views1 answer
Disableforiegn key check
SQL
21 votes242 views1 answer
Cheatsheet for sql
SQL
1 vote249 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote187 views1 answer
Sql truncate table referencing itself
SQL
0 vote237 views1 answer
Sql max of two values
SQL
19 votes216 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote263 views1 answer
Show all sequences postgres
SQL
6 votes232 views1 answer
Postgres get size of database
SQL
1 vote223 views2 answers
Replace text in sql
SQL
7 votes227 views3 answers
Sql fill table with info from anothe rtable
SQL