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

23 votes296 views5 answers
Sql substring
SQL
-1 vote248 views2 answers
How to display top 50 rows?
SQL
1 vote273 views1 answer
Oracle apex version view
SQL
11 votes278 views6 answers
Distinct sql
SQL
27 votes270 views6 answers
Set password mysql
SQL
1 vote282 views1 answer
Oracle nvl2
SQL
0 vote258 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote268 views1 answer
Mysql match in serialized data
SQL
0 vote290 views1 answer
Make parameters nullable in sql server
SQL
0 vote254 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL