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 vote322 views2 answers
Temp tables in sql server
SQL
0 vote309 views1 answer
Add sqlcmd to path linux
SQL
0 vote280 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote332 views1 answer
What is delimiter in mysql
SQL
13 votes287 views5 answers
Select last row mysql
SQL
0 vote272 views1 answer
Mysql select row with min date
SQL
0 vote308 views1 answer
Get current date data in mysql
SQL
0 vote309 views1 answer
How to select all fieldsin a soql query
SQL
0 vote295 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
-1 vote299 views2 answers
Sql convert date to string yyyy-mm-dd
SQL