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 vote343 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote341 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote366 views1 answer
Connect laravel to mysql on mac
SQL
5 votes361 views3 answers
Bash: mysql: command not found
SQL
0 vote346 views1 answer
Display first three characters sql
SQL
1 vote360 views1 answer
Mysql how to reset primary key
SQL
0 vote382 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote348 views1 answer
Oracle sql procedure return value
SQL
0 vote366 views1 answer
Sql mod even odd
SQL
0 vote373 views2 answers
Add new column after in sql
SQL