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

10 votes132 views5 answers
Mysql create user
SQL
14 votes159 views3 answers
Inner join sql oracle
SQL
0 vote136 views1 answer
Top 3 salary in sql
SQL
0 vote134 views1 answer
Mysql workbench format date
SQL
0 vote143 views1 answer
Download sql file of countries names
SQL
0 vote145 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
4 votes144 views2 answers
Error loading MySQLdb module.
SQL
1 vote158 views1 answer
Autocommit mysql
SQL
0 vote136 views1 answer
Oracle last connection
SQL
53 votes319 views6 answers
Sql server alter column
SQL