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 vote180 views2 answers
Sql query for getting details by id
SQL
0 vote179 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote164 views1 answer
Csv to sqlite python
SQL
31 votes189 views3 answers
Sql count
SQL
0 vote187 views1 answer
Cube oracle
SQL
8 votes188 views10 answers
Sql
SQL
0 vote215 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote175 views1 answer
Mysql terminal list table
SQL
7 votes175 views2 answers
What is sql clause
SQL
0 vote191 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL